Reference > System URLs > Scheduler URLs
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 may result in performance issues if the table is not cleaned regularly.
URL structure
- http:// host_name/path/
- The fully qualified name of the WebSphere Commerce Server and the configuration path.
name-value pair with the &
character. For a detailed description of the parameters and their values, see the list entitled Parameter values." />
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
- Required: 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 endTime's and are associated with this reference number. The reference number is located in column SCCJOBREFNUM of the SCHCONFIG table.
Example
The following removes all job status records for jobs completed before a given time:
http://myhostname/webapp/wcs/stores/servlet/CleanJob?endTime=2001:10:05:15:29:06
&URL=basemall.jsp
Behavior
- Deletes specified job status records from the SCHSTATUS database table.
Exception conditions
None.
Related concepts
Related tasks
Remove job status records from the SCHSTATUS table
Remove store-level job status records from the SCHSTATUS table
Related reference