To remove a job status record from the SCHSTATUS table, do the following:
- Open the Administration Console and select Store on the Administration Console Site/Store Selection page.
- From the Configuration menu, click Scheduler. A list of jobs
that are scheduled to run on your site displays. When removing job status
records, you have three options:
- To remove the job status record of a single job, do the following:
- 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, do the
following:
- 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 or endTime=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, do the following:
- 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, do the following:
Important: Completing this task does not stop jobs from running for your store. To stop a job from running, see Deleting a scheduled store-level job.