WebSphere Commerce database table: SCHACTIVE

The list containing what job will need to be run and the time when the job should execute.


Column Description(s):
Column NameColumn TypeDescription
SCSINSTREFNUM BIGINT NOT NULL Instance number for this run.
SCSJOBNBR BIGINT NOT NULL This number refers to a job defined in the SCHCONFIG table.
SCSACTLSTART TIMESTAMP The actual start time for this run of the job.
SCSATTLEFT INTEGER The number of retry attempts left.
SCSEND TIMESTAMP End time for the job.
SCSINSTRECOV BIGINT If this is a retry of a failed job, this column refers to the instance of the failed job.
SCSPREFSTART TIMESTAMP NOT NULL Preferred start time for this job.
SCSQUEUE CHAR(128) This column indicates what job queue this job is or was in. The queue name is of the format hostName:cloneId:applicationType
SCSRESULT CHAR(1) Result of the job: failed or success.
SCSSEQUENCE INTEGER The scheduling policy for this job.
SCSSTATE CHAR(2) NOT NULL The state of the scheduled job.
SCSPRIORITY INTEGER NOT NULL DEFAULT 5 The priority of the run of the job. Valid values are 1 to 10 and the higher the priority, the sooner the job will run when the time has expired.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I1244114 SCSPREFSTART+SCSJOBNBR Unique Index
SQL050212031309550 SCSINSTREFNUM Primary Key
I0000757 SCSJOBNBR Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_915 SCSJOBNBR SCHCONFIG SCCJOBREFNUM Cascade

Feedback