This table is a log of the status of scheduled jobs.
Column Name | Column Type | Column Description |
---|---|---|
SCSACTLSTART | TIMESTAMP NULL |
Actual start time for this run of the job. |
SCSATTLEFT | INTEGER NULL |
Number of retry attempts left. |
SCSEND | TIMESTAMP NULL |
End time for this 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 of job. |
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. |
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 job: success or fail. |
SCSSEQUENCE | INTEGER NULL |
Scheduling policy for this job. |
SCSSTATE | CHARACTER (2) NOT NULL |
State of the scheduled job. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I176135 | SCSPREFSTART, SCSJOBNBR | Unique Index |
SQL030416035102520 | SCSINSTREFNUM | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_741 | SCSJOBNBR | SCHCONFIG | SCCJOBREFNUM | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_914 | SCSINSTREFNUM | SCHERRORLOG | SCSINSTREFNUM | Cascade |