Removing job status records from the SCHSTATUS table

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

About this task

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

Procedure

  1. Open the Administration Console and select Site on the Administration Console Site/Store Selection page.
  2. Click Configuration > Scheduler. 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:
      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.