Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: SCHACTIVE
The list containing what job will need to be run and the time when the job should execute.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type I1244114 SCSPREFSTART+SCSJOBNBR Unique Index SQL100520030426840 SCSINSTREFNUM Primary Key I0000757 SCSJOBNBR Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_915 SCSJOBNBR SCHCONFIG SCCJOBREFNUM Cascade
Related reference
_vcc_freeselect_bottom_