The list containing what job will need to be run and the time when the job should execute.
Column Descriptions
| Column Name
| Column 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
| Reserved for IBM internal use.
|