Scheduler maintenance

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 using 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.

Alternatively, you can schedule the CleanJob job to run and automatically trim the size of the SCHSTATUS table. Use the endTime parameter to specify whether you want 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.

Note: When you clean up the scheduled jobs using the CleanJob command, the publishing utility can not 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.