This table is a log of the status of scheduled jobs.
Column Description(s):
Column Name | Column Type | Description |
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. |
SCSSTATE |
CHAR(2) NOT NULL |
State of the scheduled job. |
SCSPREFSTART |
TIMESTAMP NOT NULL |
Preferred start time for this job. |
SCSACTLSTART |
TIMESTAMP |
Actual start time for this run of the job. |
SCSRESULT |
CHAR(1) |
Result of job: success or fail. |
SCSQUEUE |
CHAR(128) |
Indicates the job queue. The queue name is of the format hostName:cloneId:applicationType. |
SCSEND |
TIMESTAMP |
End time for this job. |
SCSATTLEFT |
INTEGER |
Number of retry attempts left. |
SCSSEQUENCE |
INTEGER |
Scheduling policy for this job. |
SCSINSTRECOV |
BIGINT |
If this is a retry of a failed job this column refers to the instance of the failed job. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I176135 |
SCSPREFSTART+SCSJOBNBR |
Unique Index |
SQL050212031310260 |
SCSINSTREFNUM |
Primary Key |
I0000762 |
SCSJOBNBR |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_741 |
SCSJOBNBR |
SCHCONFIG |
SCCJOBREFNUM |
Cascade |
Referenced By:
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_914 |
SCSINSTREFNUM |
SCHERRORLOG |
SCSINSTREFNUM |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.