CleanJob command

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.

Command structure

http://host_name/path/
The fully qualified name of your WebSphere Commerce Server and the configuration path.

Diagram of the command structure: the command starts with the fully qualified name of your WebSphere Commerce Server and the configuration path, followed by the command name, CleanJob  and the ? character. End the command with a list of parameters in the form of name value pairs. Separate each name value pair with the & character. For a detailed description of the parameters and their values, refer to 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)
 (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

Exception conditions

None.