SRCH_SCHACTIVE
Reserved for IBM internal use. The list containing what job will need to be run and the time when the job should execute
Column Descriptions:
Name Type Description SCSINSTREFNUM BIGINT NOT NULL Instance number for this run SCSJOBNBR BIGINT NOT NULL This number refers to a job defined in the SCHCONFIG table SCSACTLSTART TIMESTAMP The actual start time for this run of the job SCSATTLEFT INTEGER The number of retry attempts left SCSEND TIMESTAMP End time for the job SCSINSTRECOV BIGINT If this is a retry of a failed job, this column refers to the instance of the failed job SCSPREFSTART TIMESTAMP NOT NULL Preferred start time for this job SCSQUEUE VARCHAR (256) This column indicates what job queue this job is or was in.
The queue name is of the format hostName:cloneId:applicationTypeSCSRESULT CHAR (1) Result of the job: failed or success SCSSEQUENCE INTEGER The scheduling policy for this job SCSSTATE CHAR (2) NOT NULL The state of the scheduled 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. TENANT_ID BIGINT NOT NULL DEFAULT 0 The ID of the tenant in the multi-tenant environment OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.
Indexes:
Name Column Names Type P_0045 SCSINSTREFNUM Primary Key I0001542 SCSPREFSTART+SCSJOBNBR Unique Index