SRCH_SCHACTIVE

Reserved for HCL internal use. 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
SCSQUEUEVARCHAR (256)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.
TENANT_IDBIGINT NOT NULL DEFAULT 0The ID of the tenant in the multi-tenant environment
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
P_0045SCSINSTREFNUMPrimary Key
I0001542SCSPREFSTART+SCSJOBNBRUnique Index