Administer > Overview of administering a WebSphere Commerce site > Administration Console > Scheduler > Jobs
Maintain the scheduler
The SCHSTATUS table contains one entry for every execution of a job in the SCHCONFIG table. Because of the large volume of jobs run by the scheduler, job status records kept in the SCHSTATUS table become quite numerous. This can have an adverse affect on the performance of the WebSphere Commerce Server. It is therefore recommended that you periodically clean up the SCHSTATUS table.
Procedure
- Use the Scheduler Status Display page.
This is located in the Administration Console under the Configuration menu.
Deleting job status records reduces the size of the SCHSTATUS table by cleaning up jobs based on time stamp and job reference number.
- Schedule the CleanJob job to run and automatically trim the size of the SCHSTATUS table.
Use the endTime parameter to specify whether to remove job status records for the previous week or the previous month.
When the CleanJob command is used to trim the size of the SCHSTATUS table, it is not logged into the table itself. When you clean up the scheduled jobs using the CleanJob command, the publishing utility cannot retrieve the publish status for previously published store archives. As a result, the publish status for a successfully published store archive will be Not Published, although the store archive has already been successfully published.
- Set the autoClean parameter to "on" in the configuration file.
This parameter causes all SCHSTATUS entries to be removed whenever the job completes.