This table contains all scheduled job entries.
Column Description(s):
Column Name | Column Type | Description |
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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | 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 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.