SCHACTIVE

The list containing what job will need to be run and the time when the job should execute.

Column Descriptions:

NameTypeDescription
SCSINSTREFNUMBIGINT NOT NULLInstance number for this run.
SCSJOBNBRBIGINT NOT NULLThis number refers to a job defined in the SCHCONFIG table.
SCSACTLSTARTTIMESTAMPThe actual start time for this run of the job.
SCSATTLEFTINTEGERThe number of retry attempts left.
SCSENDTIMESTAMPEnd time for the job.
SCSINSTRECOVBIGINTIf this is a retry of a failed job, this column refers to the instance of the failed job.
SCSPREFSTARTTIMESTAMP NOT NULLPreferred start time for this job.
SCSQUEUECHAR (128)This column indicates what job queue this job is or was in. The queue name is of the format hostName:cloneId:applicationType
SCSRESULTCHAR (1)Result of the job: failed or success.
SCSSEQUENCEINTEGERThe scheduling policy for this job.
SCSSTATECHAR (2) NOT NULLThe state of the scheduled job.
SCSPRIORITYINTEGER NOT NULL DEFAULT 5The 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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SCSINSTREFNUMPrimary Key
I1244114SCSPREFSTART+SCSJOBNBRUnique Index
I0000757SCSJOBNBRNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_915SCSJOBNBRSCHCONFIGSCCJOBREFNUMCascade