The list containing what job will need to be run
and the time when the job should execute.
Column Descriptions:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | SCSINSTREFNUM | Primary Key |
I1244114 | SCSPREFSTART+SCSJOBNBR | Unique Index |
I0000757 | SCSJOBNBR | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_915 | SCSJOBNBR | SCHCONFIG | SCCJOBREFNUM | Cascade |