Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: SCHCONFIG
This table contains all scheduled job entries.
Column Name Column 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. 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. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000226 SCCJOBREFNUM+SCCSEQUENCE Unique Index SQL100520030427300 SCCJOBREFNUM Primary Key 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
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_738 MEMBER_ID MEMBER MEMBER_ID Cascade F_737 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_959 SCCJOBREFNUM EMLPROMO SCCJOBREFNUM Cascade F_985 SCCJOBREFNUM FILEUPLOAD SCCJOBREFNUM Cascade F_915 SCSJOBNBR SCHACTIVE SCCJOBREFNUM Cascade F_735 JOBREFNUM SCHBRDCST SCCJOBREFNUM Cascade F_739 JOB_RN SCHORDERS SCCJOBREFNUM Cascade F_741 SCSJOBNBR SCHSTATUS SCCJOBREFNUM Cascade F_1094 JOBID SHDCACRM SCCJOBREFNUM Cascade