Reserved for HCL internal use. 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 | VARCHAR (256) | 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. |
TENANT_ID | BIGINT NOT NULL DEFAULT 0 | The ID of the tenant in the multi-tenant
environment |
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 |
P_0045 | SCSINSTREFNUM | Primary Key |
I0001542 | SCSPREFSTART+SCSJOBNBR | Unique Index |