Reserved for HCL internal use. 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 |
COMMAND | VARCHAR (256) | The job command name |
SCCQUERY | VARCHAR (3000) | Query string for the scheduled command |
SCCSTART | TIMESTAMP NOT NULL | Scheduled start time for the job |
SCCINTERVALTYPE | CHAR (1) NOT NULL DEFAULT 'S' | Unit of time for repeating the job at the
interval value |
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 | VARCHAR (20) | Application type |
TENANT_ID | BIGINT NOT NULL DEFAULT 0 | The ID of the tenant in the multi-tenant
environment |
OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | 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 |
P_0047 | SCCJOBREFNUM | Primary Key |