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


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search