WebSphere Commerce database table: SCHSTATUS

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


Column Description(s):
Column NameColumn TypeDescription
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.
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.
SCSEND TIMESTAMP End time for this job.
SCSATTLEFT INTEGER Number of retry attempts left.
SCSSEQUENCE INTEGER Scheduling 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(es):
Index NameIndexed Column NamesIndex Type
I176135 SCSPREFSTART+SCSJOBNBR Unique Index
SQL050212031310260 SCSINSTREFNUM Primary Key
I0000762 SCSJOBNBR Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_741 SCSJOBNBR SCHCONFIG SCCJOBREFNUM Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_914 SCSINSTREFNUM SCHERRORLOG SCSINSTREFNUM Cascade

Feedback