WebSphere Commerce database table: SCHSTATUS

Reference > Database > WebSphere Commerce database tables > S

WebSphere Commerce database table: SCHSTATUS

This table is a log of the status of scheduled jobs.

Column Name Column Type Description
SCSINSTREFNUM BIGINT NOT NULL Instance number for this run of job.
SCSJOBNBR BIGINT NOT NULL This number refers to a job defined in the SCHCONFIG table.
SCSSTATE CHAR(2) NOT NULL State of the scheduled job.

I

The scheduled job must run at the preferred start time, recorded in the SCSPREFSTART column of the SCHSTATUS or SCHACTIVE table.

IF

The scheduled job is rescheduled to run. There was a previous failed attempt to execute the job.

R

The scheduled job is running. The job execution start time is recorded in either the SCSACTLSTART column of the SCHSTATUS table or SCHACTIVE table. The SCSQUEUE column indicates which JVM process is running the job.

RF

The scheduled job is running. There was a previous failed attempt to execute the job.

C

The scheduled job has completed successfully. The job execution finish time is recorded in the SCSEND column of either the SCHSTATUS table or the SCHACTIVE table.

CF

The same as state C except there was an exception while executing the scheduled job. The job failed to execute successfully.

W

There is a check task command assigned to the scheduled job. This means that before the job is executed, there is a side process that will execute to determine whether the job really needs to be run. This saves the overhead of running a scheduled job when it does not need to be run. (This parameter is mostly used for store level scheduled jobs.)

SCSPREFSTART TIMESTAMP NOT NULL Preferred start time for this job.
SCSACTLSTART TIMESTAMP Actual start time for this run of the job.
SCSRESULT CHAR(1) Result of job: success or fail.
SCSQUEUE CHAR(128) Indicates the job queue. The queue name is of the format hostName:cloneId:applicationType, where the hostName and applicationType components are defined in the SCHCONFIG table and cloneId is generated.
SCSEND TIMESTAMP End time for this job.
SCSATTLEFT INTEGER Number of retry attempts left.
SCSSEQUENCE INTEGER Schedule policy for this job.
SCSINSTRECOV BIGINT If this is a retry of a failed job this column refers to the instance of the failed job.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I176135 SCSPREFSTART+SCSJOBNBR Unique Index
SQL100520030427610 SCSINSTREFNUM Primary Key
I0000762 SCSJOBNBR Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_741 SCSJOBNBR SCHCONFIG SCCJOBREFNUM Cascade

Referenced By
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_914 SCSINSTREFNUM SCHERRORLOG SCSINSTREFNUM Cascade

Related reference

Job scheduler data model

_vcc_freeselect_bottom_

+
Search Tips | Advanced Search

Column Name	Column Type	Description
SCSINSTREFNUM	BIGINT NOT NULL	Instance number for this run of job.
SCSJOBNBR	BIGINT NOT NULL	This number refers to a job defined in the SCHCONFIG table.
SCSSTATE	CHAR(2) NOT NULL	State of the scheduled job. I The scheduled job must run at the preferred start time, recorded in the SCSPREFSTART column of the SCHSTATUS or SCHACTIVE table. IF The scheduled job is rescheduled to run. There was a previous failed attempt to execute the job. R The scheduled job is running. The job execution start time is recorded in either the SCSACTLSTART column of the SCHSTATUS table or SCHACTIVE table. The SCSQUEUE column indicates which JVM process is running the job. RF The scheduled job is running. There was a previous failed attempt to execute the job. C The scheduled job has completed successfully. The job execution finish time is recorded in the SCSEND column of either the SCHSTATUS table or the SCHACTIVE table. CF The same as state C except there was an exception while executing the scheduled job. The job failed to execute successfully. W There is a check task command assigned to the scheduled job. This means that before the job is executed, there is a side process that will execute to determine whether the job really needs to be run. This saves the overhead of running a scheduled job when it does not need to be run. (This parameter is mostly used for store level scheduled jobs.)
SCSPREFSTART	TIMESTAMP NOT NULL	Preferred start time for this job.
SCSACTLSTART	TIMESTAMP	Actual start time for this run of the job.
SCSRESULT	CHAR(1)	Result of job: success or fail.
SCSQUEUE	CHAR(128)	Indicates the job queue. The queue name is of the format hostName:cloneId:applicationType, where the hostName and applicationType components are defined in the SCHCONFIG table and cloneId is generated.
SCSEND	TIMESTAMP	End time for this job.
SCSATTLEFT	INTEGER	Number of retry attempts left.
SCSSEQUENCE	INTEGER	Schedule policy for this job.
SCSINSTRECOV	BIGINT	If this is a retry of a failed job this column refers to the instance of the failed job.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
I176135	SCSPREFSTART+SCSJOBNBR	Unique Index
SQL100520030427610	SCSINSTREFNUM	Primary Key
I0000762	SCSJOBNBR	Non-Unique Index