This table is a log of the status of scheduled
jobs
Column Descriptions:
| Name | Type | Description |
| SCSINSTREFNUM | BIGINT NOT NULL | Instance number for this run of job |
| SCSJOBNBR | BIGINT NOT NULL | This number refers to a job defined in the
SCHCONFIG table |
| SCSSTATE | CHAR (2) NOT NULL | State of the scheduled job.
- I - The scheduled job must run at the preferred start time,
recorded in the SCSPREFSTART column of the SCHSTATUS or SCHACTIVE
table
- IF - The scheduled job is rescheduled to run. There was a
previous failed attempt to execute the job.
- R - The scheduled job is running. The job execution start time
is recorded in either the SCSACTLSTART column of the SCHSTATUS
table or SCHACTIVE table. The SCSQUEUE column indicates which JVM
process is running the job.
- RF - The scheduled job is running. There was a previous failed
attempt to execute the job.
- 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.
- CF - The same as state C except there was an exception while
executing the scheduled job. The job failed to execute
successfully.
- W - There is a check task command assigned to the scheduled
job. This means that before the job is executed, there is a side
process that will execute to determine whether the job really needs
to be run. This saves the overhead of running a scheduled job when
it does not need to be run. (This parameter is mostly used for
store level scheduled jobs)
|
| SCSPREFSTART | TIMESTAMP NOT NULL | Preferred start time for this job |
| SCSACTLSTART | TIMESTAMP | Actual start time for this run of the job |
| SCSRESULT | CHAR (1) | Result of job: success or fail |
| SCSQUEUE | VARCHAR (128) | Indicates the job queue.
The queue name is of the format
hostName:cloneId:applicationType,
where the hostName and applicationType components are defined
in the SCHCONFIG table and cloneId is generated |
| SCSEND | TIMESTAMP | End time for this job |
| SCSATTLEFT | INTEGER | Number of retry attempts left |
| SCSSEQUENCE | INTEGER | Scheduling policy for this job |
| SCSINSTRECOV | BIGINT | If this is a retry of a failed job this column
refers to the instance of the failed job |
| TENANT_ID | BIGINT NOT NULL DEFAULT 0 | The ID of the tenant in the multi-tenant
environment |
| 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 |
| P_0049 | SCSINSTREFNUM | Primary Key |
| I0001543 | SCSPREFSTART+SCSJOBNBR | Unique Index |