Remove job status records from the SCHSTATUS table

Use the Administration Console to remove job status records from the SCHSTATUS table.

  1. Open the Administration Console and select Site on the Administration Console Site/Store Selection page.

  2. 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:

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

      2. 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:

      1. Schedule the CleanJob job to run.

      2. 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:

      1. Click Remove All Records. A message displays asking if you are sure you want to delete all job status records.

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


Completing this task does not stop the job from running for your site. To stop a job from running, see Deleting a scheduled job.

 

Related Concepts


Scheduler

 

Related tasks


Maintaining the scheduler
Scheduling a site-level job
Deleting a scheduled job
Remove store-level job status records from the SCHSTATUS table

 

Related Reference


Scheduled job states