Database Table: SCHCONFIG

This table contains all the scheduled job entries.

Column Name Column Type Column Description
INTERFACENAME VARCHAR (254)
NULL
The interface of the check command which indicates whether the scheduled job needs to be executed or not.
MEMBER_ID BIGINT
NOT NULL
Owner of the scheduled job.
SCCACTIVE CHARACTER (1)
NOT NULL, DEFAULT 'A'
Job active indicator.
SCCAPPTYPE CHARACTER (20)
NULL
Application type.
SCCHOST VARCHAR (128)
NULL
The host name.
SCCINTERVAL INTEGER
NULL
Job reschedule interval in seconds.
SCCJOBREFNUM BIGINT
NOT NULL
Job reference number.
SCCPATHINFO VARCHAR (254)
NOT NULL
Command name.
SCCPRIORITY INTEGER
NOT NULL, DEFAULT 0
Priority.
SCCQUERY VARCHAR (3000)
NULL
Query string for the scheduled command.
SCCRECATT INTEGER
NOT NULL, DEFAULT 0
Retry attempt count.
SCCRECDELAY INTEGER
NOT NULL, DEFAULT 0
Delay in seconds between attempts.
SCCSEQUENCE INTEGER
NOT NULL, DEFAULT 0
Job sequence number.
SCCSTART TIMESTAMP
NOT NULL
Scheduled start time for the job.
STOREENT_ID INTEGER
NOT NULL, DEFAULT 0
The store ID of the store that the scheduled job is running for.
Indexes:
Index Name Indexed Column Names Index Type
I0000226 SCCJOBREFNUM, SCCSEQUENCE Unique Index
I0000321 SCCPATHINFO Non-Unique Index
I0000322 SCCHOST Non-Unique Index
I0000323 SCCAPPTYPE Non-Unique Index
SQL030416035101850 SCCJOBREFNUM Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_737 STOREENT_ID STOREENT STOREENT_ID Cascade
F_738 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
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