CleanJob URL

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 WebSphere Commerce 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

Required: The URL to be called when the command completes successfully.

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 endTime's 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.