11
The form "Batch jobs" will over time be filled with ended jobs. We need a cleaning job!

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
Category: General
STATUS DETAILS
Needs Votes

Comments

S

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

S

This is a wonderful idea!

Category: General

S

Along with BatchJob table, we should be consider deleting Batch table.

Category: General