Removing job status records from the SCHSTATUS table

Use Management Center Tools 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


  2. Open Management Center Tools and from the hamburger menu, click System Administration > Scheduler.
  3. HCL Commerce Version 9.1.16.0 or later Open Management Center tools and from the left navigation menu, click Administration > System Administration > Scheduler.

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