Removing job status records from the SCHSTATUS table
Use the Administration Console to remove job status records from the SCHSTATUS table.
About this task
Procedure
- Open the Administration Console and select Site on the Administration Console Site/Store Selection page.
-
Click
. A list of jobs that are scheduled to run is displayed.When removing job status records, you have three options:
- To remove the job status record of a single job:
- Select the check box for the job status record you want to remove and click Remove Record. A message displays asking if you are sure you want to delete the selected job status record.
- Click OK to confirm the deletion. The job status record is removed from the SCHSTATUS table and cleared from the Scheduler Status Display page.
- To remove the job status records for the previous week or month:
- Schedule the CleanJob job to run.
- In the queryString you enter in the Job parameters field, specify the
parameter
endTime=LASTWEEK
to remove job records for the last week orendTime=LASTMONTH
to remove job records for the last month. All job status records for the specified time period are removed when the scheduler runs the job.
- To remove the job status records of all jobs:
- Click Remove All Records. A message displays asking if you are sure you want to delete all job status records.
- Click OK to confirm the deletion. The job status records for all jobs are removed from the SCHSTATUS table and cleared from the Scheduler Status Display page.
- To remove the job status record of a single job: