SCHCONFIG

This table contains all scheduled job entries.

Column Descriptions:

NameTypeDescription
SCCJOBREFNUMBIGINT NOT NULLJob reference number.
SCCHOSTVARCHAR (128)The host name of the instance on which the scheduled job will be run.
MEMBER_IDBIGINT NOT NULLOwner of the scheduled job.
STOREENT_IDINTEGER NOT NULL DEFAULT 0The store ID of the store for which the scheduled job is running.
SCCRECDELAYINTEGER NOT NULL DEFAULT 0Delay in seconds between attempts.
SCCRECATTINTEGER NOT NULL DEFAULT 0Retry attempt count.
SCCPATHINFOVARCHAR (254) NOT NULLCommand name.
SCCQUERYVARCHAR (3000)Query string for the scheduled command.
SCCSTARTTIMESTAMP NOT NULLScheduled start time for the job.
SCCINTERVALINTEGERJob reschedule interval in seconds.
SCCPRIORITYINTEGER NOT NULL DEFAULT 0Priority.
SCCSEQUENCEINTEGER NOT NULL DEFAULT 0Job sequence number.
SCCACTIVECHAR (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.
SCCAPPTYPECHAR (20)Application type.
INTERFACENAMEVARCHAR (254)The interface of the check command which indicates whether the scheduled job needs to be executed or not.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>SCCJOBREFNUMPrimary Key
I0000226SCCJOBREFNUM+SCCSEQUENCEUnique Index
I0000321SCCPATHINFONon-Unique Index
I0000322SCCHOSTNon-Unique Index
I0000323SCCAPPTYPENon-Unique Index
I0000759MEMBER_IDNon-Unique Index
I0000760STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_737STOREENT_IDSTOREENTSTOREENT_IDCascade
F_738MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1094SCCJOBREFNUMSHDCACRMJOBIDCascade
F_735SCCJOBREFNUMSCHBRDCSTJOBREFNUMCascade
F_739SCCJOBREFNUMSCHORDERSJOB_RNCascade
F_741SCCJOBREFNUMSCHSTATUSSCSJOBNBRCascade
F_915SCCJOBREFNUMSCHACTIVESCSJOBNBRCascade
F_959SCCJOBREFNUMEMLPROMOSCCJOBREFNUMCascade
F_985SCCJOBREFNUMFILEUPLOADSCCJOBREFNUMCascade