This table contains all the scheduled job entries.
Column Name | Column Type | Column Description |
---|---|---|
INTERFACENAME | VARCHAR (254) NULL |
The interface of the check command which indicates whether the scheduled job needs to be executed or not. |
MEMBER_ID | BIGINT NOT NULL |
Owner of the scheduled job. |
SCCACTIVE | CHARACTER (1) NOT NULL, DEFAULT 'A' |
Job active indicator. |
SCCAPPTYPE | CHARACTER (20) NULL |
Application type. |
SCCHOST | VARCHAR (128) NULL |
The host name. |
SCCINTERVAL | INTEGER NULL |
Job reschedule interval in seconds. |
SCCJOBREFNUM | BIGINT NOT NULL |
Job reference number. |
SCCPATHINFO | VARCHAR (254) NOT NULL |
Command name. |
SCCPRIORITY | INTEGER NOT NULL, DEFAULT 0 |
Priority. |
SCCQUERY | VARCHAR (3000) NULL |
Query string for the scheduled command. |
SCCRECATT | INTEGER NOT NULL, DEFAULT 0 |
Retry attempt count. |
SCCRECDELAY | INTEGER NOT NULL, DEFAULT 0 |
Delay in seconds between attempts. |
SCCSEQUENCE | INTEGER NOT NULL, DEFAULT 0 |
Job sequence number. |
SCCSTART | TIMESTAMP NOT NULL |
Scheduled start time for the job. |
STOREENT_ID | INTEGER NOT NULL, DEFAULT 0 |
The store ID of the store that the scheduled job is running for. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000226 | SCCJOBREFNUM, SCCSEQUENCE | Unique Index |
I0000321 | SCCPATHINFO | Non-Unique Index |
I0000322 | SCCHOST | Non-Unique Index |
I0000323 | SCCAPPTYPE | Non-Unique Index |
SQL030416035101850 | SCCJOBREFNUM | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_737 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
F_738 | MEMBER_ID | MEMBER | MEMBER_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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 |