The SCHSTATUS table contains one entry for every execution of a job in the SCHCONFIG
table. Because of the large number of jobs that are run by the scheduler, there are many job status
records in the SCHSTATUS table. This size can have an adverse affect on the performance of the
Transaction server. Periodically clean up the SCHSTATUS table.
Procedure
-
Use the Administration Console Scheduler Status Display page to delete
jobs. 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 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 in to the table itself.
When you clean up the scheduled jobs by 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 was 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.