Database Table: SCHSTATUS

This table is a log of the status of scheduled jobs.

Column Name Column Type Column Description
SCSACTLSTART TIMESTAMP
NULL
Actual start time for this run of the job.
SCSATTLEFT INTEGER
NULL
Number of retry attempts left.
SCSEND TIMESTAMP
NULL
End time for this 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 of job.
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.
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 job: success or fail.
SCSSEQUENCE INTEGER
NULL
Scheduling policy for this job.
SCSSTATE CHARACTER (2)
NOT NULL
State of the scheduled job.
Indexes:
Index Name Indexed Column Names Index Type
I176135 SCSPREFSTART, SCSJOBNBR Unique Index
SQL030416035102520 SCSINSTREFNUM Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_741 SCSJOBNBR SCHCONFIG SCCJOBREFNUM Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_914 SCSINSTREFNUM SCHERRORLOG SCSINSTREFNUM Cascade