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 | CHAR (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. |
| 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> | SCSINSTREFNUM | Primary Key |
| I176135 | SCSPREFSTART+SCSJOBNBR | Unique Index |
| I0000762 | SCSJOBNBR | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_741 | SCSJOBNBR | SCHCONFIG | SCCJOBREFNUM | Cascade |
Referenced By Child Tables:
| Constraint | Columns | Child Table | Child Columns | Type |
| F_914 | SCSINSTREFNUM | SCHERRORLOG | SCSINSTREFNUM | Cascade |