This table contains 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. |
OPTCOUNTER | SMALLINT | 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 |