Clean up the job batch history

When you run a batch job, a history is recorded. This history can be used to monitor the correct execution of jobs. However, when several batch jobs have been created, especially batch jobs that have a high recurrence, lots of batch job history entries are generated. Too many entries in the history table can negatively affect the performance of future jobs.

Two pages that have been added to the System administration module make it easy to clean up the batch job history:

  • Batch job history clean-up
  • Custom batch job history clean-up

Periodic tasks in System administration

Note

We recommend that you regularly clean up the batch job history, and that you do this cleanup outside of business hours.

Batch job history clean-up

Follow these steps to quickly clean up all history entries that are older than a specified number of days.

  1. On the Periodic tasks in System administration module, select Batch job history clean-up.
  2. In the History limit (days) field, specify the number of days to keep a history of batch jobs.
  3. Select OK.

Regular job

Batch job history clean-up (custom)

The custom batch job lets you to apply additional filtering, based on criteria such as status, job description, company, or user. You can also add other filter criteria by selecting the Filter button.

  1. On the Periodic tasks in System administration module, select Batch job history clean-up (custom).
  2. In the History limit (days) field, specify the number of days to keep a history of batch jobs.
  3. On the Records to include FastTab, specify any filter criteria that you require, and then select OK.
  4. Select OK.

Custom job