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