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 | 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 |