CleanJob URL
This command removes job status records from the WebSphere Commerce scheduler status table.
This command removes job status records from the WebSphere Commerce scheduler status table,
SCHSTATUS, based on timestamp or timestamp and job reference number. Use this
command to trim the size of the scheduler status table. Under heavy scheduler use, the number of
entries in this table grows tremendously large. This might result in performance issues if the table
is not cleaned regularly.
URL structure
- http:// host_name/path/
- The fully qualified name of your Transaction Server and the configuration path.
Parameter values
- langId
- Sets or resets the preferred language for the duration of the session; the supported languages for a store are found in the STORELANG table.
- URL
- Optional: The URL to be called when the command completes successfully.
- endTime
- Required: Deletes all job status records preceding and including the specified time. Specifying the key "LASTWEEK" deletes all job status records from the previous week. Specifying the key "LASTMONTH" deletes all job status records from the previous month.
- jobId
- Deletes all job instance entries that completed before the end time and are associated with this reference number. The reference number is in column SCCJOBREFNUM of the SCHCONFIG table.
Example
The following removes all job status records for jobs that are completed before a specified time:
http://myhostname/webapp/wcs/stores/servlet/CleanJob?endTime=LASTWEEK&URL=basemall.jsp
http://myhostname/webapp/wcs/stores/servlet/CleanJob?endTime=LASTWEEK
Behavior
- Deletes specified job status records from the SCHSTATUS database table.
Exception conditions
None.
Related tasks
Scheduling a broadcast job
Deleting a scheduled job
Editing the configuration for a scheduled job
Maintaining the scheduler
Scheduling a site-level job
Removing job status records from the SCHSTATUS table