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

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.

Related concepts

Scheduler

Related tasks

Maintaining the scheduler
Remove job status records from the SCHSTATUS table
Remove store-level job status records from the SCHSTATUS table

Related reference

ActivityCleanUp URL
AddJob URL
AddBroadcastJob URL
EditJob URL
PaySynchronizePM URL
RaiseECEvent URL
RemoveJob URL
ScheduledDataDeploy URL
SchedCoupon URL
TicklerUnlockMonitor URL
System URLs