CSO_BATCH_STATUS
This table contains the status of the batch jobs that were run.
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
CSO_BATCH_STATUS_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
| JOB_ID | VARCHAR2 | 32 | Yes | This is the job id of the batch job. |
| DATE_FIRED | TIMESTAMP | Yes | The last datetime when the job was run. | |
| STATUS | VARCHAR2 | 10 | Indicates the status of a running or completed job. | |
| STATUS_OUTPUT | VARCHAR2 | 1000 | Additional job status information consisting of progress or completion details. | |
| DATE_ADDED | TIMESTAMP | Yes | This is the datetime that the record was added to the repository. | |
| DATE_MODIFIED | TIMESTAMP | Yes | This is the datetime that the record was modified. | |
| HEART_BEAT_DATE | TIMESTAMP | Yes | The most recent datetime for which status information was updated for this job. | |
| LOG_ERRORS_WARNINGS | CLOB | Optional log of errors and warnings, stored as comma-separated values. | ||
| LOG_SUMMARY | CLOB | Optional summary log, stored as comma-separated values. | ||
| EXTERNAL_REFERENCE_KEY | VARCHAR2 | 256 | Associates this status record with an externally generated request, typically a message identifier from the Enterprise Scheduling Service. | |
| CANCEL_REQUESTED_FLAG | VARCHAR2 | 1 | Indicates whether a cancellation request occurred for the job associated with this status record. A value of 'Y' indicates that cancellation was requested, any other value indicates that it was not. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_BATCH_STATUS_N1 | Non Unique | Default | JOB_ID |
| CSO_BATCH_STATUS_U1 | Unique | Default | RECORD_ID |