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 |