SCHCONFIG

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.
SCCPATHINFO	VARCHAR (254) NOT NULL	Command name.
SCCQUERY	VARCHAR (3000)	Query string for the scheduled command.
SCCSTART	TIMESTAMP NOT NULL	Scheduled start time for the job.
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	CHAR (20)	Application type.
INTERFACENAME	VARCHAR (254)	The interface of the check command which indicates whether the scheduled job needs to be executed or not.
SCCDESCRIPTION	VARCHAR (3000)	The column that describes the CustomJob command.
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
<SYSTEM-GENERATED>	SCCJOBREFNUM	Primary Key
I0000226	SCCJOBREFNUM+SCCSEQUENCE	Unique Index
I0000321	SCCPATHINFO	Non-Unique Index
I0000322	SCCHOST	Non-Unique Index
I0000323	SCCAPPTYPE	Non-Unique Index
I0000759	MEMBER_ID	Non-Unique Index
I0000760	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_737	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_738	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1094	SCCJOBREFNUM	SHDCACRM	JOBID	Cascade
F_735	SCCJOBREFNUM	SCHBRDCST	JOBREFNUM	Cascade
F_739	SCCJOBREFNUM	SCHORDERS	JOB_RN	Cascade
F_741	SCCJOBREFNUM	SCHSTATUS	SCSJOBNBR	Cascade
F_915	SCCJOBREFNUM	SCHACTIVE	SCSJOBNBR	Cascade
F_959	SCCJOBREFNUM	EMLPROMO	SCCJOBREFNUM	Cascade
F_985	SCCJOBREFNUM	FILEUPLOAD	SCCJOBREFNUM	Cascade