SCHACTIVE

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

Related reference
Scheduler data model