The list containing what job will need to be run and the time when the job should execute.
Column Description(s):
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. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I1244114 |
SCSPREFSTART+SCSJOBNBR |
Unique Index |
SQL050212031309550 |
SCSINSTREFNUM |
Primary Key |
I0000757 |
SCSJOBNBR |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_915 |
SCSJOBNBR |
SCHCONFIG |
SCCJOBREFNUM |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.