The list containing what job will need to be run and the time when the job should execute.
Column Name | Column Type | Column Description |
---|---|---|
SCSACTLSTART | TIMESTAMP NULL |
The actual start time for this run of the job. |
SCSATTLEFT | INTEGER NULL |
The number of retry attempts left. |
SCSEND | TIMESTAMP NULL |
End time for the job. |
SCSINSTRECOV | BIGINT NULL |
If this is a retry of a failed job, this column refers to the instance of the failed job. |
SCSINSTREFNUM | BIGINT NOT NULL |
Instance number for this run. |
SCSJOBNBR | BIGINT NOT NULL |
This number refers to a job defined in the SCHCONFIG table. |
SCSPREFSTART | TIMESTAMP NOT NULL |
Preferred start time for this 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. |
SCSQUEUE | CHARACTER (128) NULL |
This column indicates what job queue this job is or was in. The queue name is of the format hostName:cloneId:applicationType |
SCSRESULT | CHARACTER (1) NULL |
Result of the job: failed or success. |
SCSSEQUENCE | INTEGER NULL |
The scheduling policy for this job. |
SCSSTATE | CHARACTER (2) NOT NULL |
The state of the scheduled job. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I1244114 | SCSPREFSTART, SCSJOBNBR | Unique Index |
SQL030416035100790 | SCSINSTREFNUM | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_915 | SCSJOBNBR | SCHCONFIG | SCCJOBREFNUM | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|