WebSphere Commerce database table: SCHCONFIG

This table contains all scheduled job entries.


Column Description(s):
Column NameColumn TypeDescription
SCCJOBREFNUM BIGINT NOT NULL Job reference number.
SCCHOST VARCHAR(128) The host name.
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000226 SCCJOBREFNUM+SCCSEQUENCE Unique Index
SQL050212031309970 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
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_738 MEMBER_ID MEMBER MEMBER_ID Cascade
F_737 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback