I would like to have a periodic job that could delete records from the table BatchJob.
Filter:
-Status (Never delete status "Waiting" or "Executing")
-OrigStartDateTime
-Caption
Comments
Yes, this is a very good idea.
Every inbound message that is passed through the Data Management framework using Package API will create a one-time Batch Job that ends up in status Ended. These batch jobs are never deleted. I have to do it manually to avoid performance problems. We are importing about 1000 messages/day, so it takes some time to do this deletion manually.
Alternatively, the delete of job history in Data Management should also include a delete of its corresponding batch job. But the above solution is better, in my opinion, as it is more generic.
Category: General
This is a wonderful idea!
Category: General
Along with BatchJob table, we should be consider deleting Batch table.
Category: General