Database Table: SCHACTIVE

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

Column Name Column Type Column Description
SCSACTLSTART TIMESTAMP
NULL
The actual start time for this run of the job.
SCSATTLEFT INTEGER
NULL
The number of retry attempts left.
SCSEND TIMESTAMP
NULL
End time for the job.
SCSINSTRECOV BIGINT
NULL
If this is a retry of a failed job, this column refers to the instance of the failed job.
SCSINSTREFNUM BIGINT
NOT NULL
Instance number for this run.
SCSJOBNBR BIGINT
NOT NULL
This number refers to a job defined in the SCHCONFIG table.
SCSPREFSTART TIMESTAMP
NOT NULL
Preferred start time for this 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.
SCSQUEUE CHARACTER (128)
NULL
This column indicates what job queue this job is or was in. The queue name is of the format hostName:cloneId:applicationType
SCSRESULT CHARACTER (1)
NULL
Result of the job: failed or success.
SCSSEQUENCE INTEGER
NULL
The scheduling policy for this job.
SCSSTATE CHARACTER (2)
NOT NULL
The state of the scheduled job.
Indexes:
Index Name Indexed Column Names Index Type
I1244114 SCSPREFSTART, SCSJOBNBR Unique Index
SQL030416035100790 SCSINSTREFNUM Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_915 SCSJOBNBR SCHCONFIG SCCJOBREFNUM Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable