SCHERRORLOG

This table contains the exception information when a job fails to execute successfully.

Column Descriptions:

NameTypeDescription
SCSINSTREFNUMBIGINT NOT NULLThe instance of when the job ran.
SCSERRORCLOB (1000000)The error recorded for the run of the job.
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

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_914SCSINSTREFNUMSCHSTATUSSCSINSTREFNUMCascade