SRCH_SCHCONFIG

Reserved for HCL internal use. This table contains all scheduled job entries

Column Descriptions:

Name	Type	Description
SCCJOBREFNUM	BIGINT NOT NULL	Job reference number
SCCHOST	VARCHAR (128)	The host name of the instance on which the scheduled job will be run
MEMBER_ID	BIGINT NOT NULL	Owner of the scheduled job
STOREENT_ID	INTEGER NOT NULL DEFAULT 0	The store ID of the store for which the scheduled job is running
SCCRECDELAY	INTEGER NOT NULL DEFAULT 0	Delay in seconds between attempts
SCCRECATT	INTEGER NOT NULL DEFAULT 0	Retry attempt count
COMMAND	VARCHAR (256)	The job command name
SCCQUERY	VARCHAR (3000)	Query string for the scheduled command
SCCSTART	TIMESTAMP NOT NULL	Scheduled start time for the job
SCCINTERVALTYPE	CHAR (1) NOT NULL DEFAULT 'S'	Unit of time for repeating the job at the interval value
SCCINTERVAL	INTEGER	Job reschedule interval in seconds
SCCPRIORITY	INTEGER NOT NULL DEFAULT 0	Priority
SCCSEQUENCE	INTEGER NOT NULL DEFAULT 0	Job sequence number
SCCACTIVE	CHAR (1) NOT NULL DEFAULT 'A'	Job active indicator: A - The scheduled job is active for the next run C - The scheduled job has completed successfully. The job execution finish time is recorded in the SCSEND column of either the SCHSTATUS table or the SCHACTIVE table. I - The scheduled job must run at the preferred start time, recorded in the SCSPREFSTART column of the SCHSTATUS or SCHACTIVE table N - The scheduled job is not configured
SCCAPPTYPE	VARCHAR (20)	Application type
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_0047	SCCJOBREFNUM	Primary Key