SCHCONFIG
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
Related reference
Contract data model
Scheduler data model