CSO_BATCH_JOBS
This table contains a listing of all defined batch jobs for a repository
Details
-
Schema: FUSION
-
Object owner: CSO
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
CSO_BATCH_JOBS_PK |
RECORD_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| RECORD_ID | VARCHAR2 | 32 | Yes | This is the primary key of the table. |
| DATE_ADDED | TIMESTAMP | Yes | This is the date that the record was added to the repository. | |
| DATE_MODIFIED | TIMESTAMP | This is the date that the record was modified. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. |
| JOB_NAME | VARCHAR2 | 50 | Yes | Descriptive name for the batch job |
| TRIGGER_NAME | VARCHAR2 | 50 | Yes | This is the Trigger name for this record. |
| GROUP_NAME | VARCHAR2 | 50 | Yes | This is the key used to reference the Repository. |
| JOB_START | TIMESTAMP | Yes | Timestamp when the job is scheduled to run. | |
| JOB_END | TIMESTAMP | Timestamp when the batch job is scheduled to end. | ||
| REPEATS | NUMBER | Indicates the number of times a job should repeat (0=run once, -1= run forever) | ||
| DELAY | NUMBER | This is the number of minutes between job runs. | ||
| NEXT_FIRE_DATE | TIMESTAMP | Next scheduled run date for batch job | ||
| REF_KEY | VARCHAR2 | 50 | Non-localized name of the batch job | |
| JOB_COMMAND | VARCHAR2 | 255 | Yes | Command to be executed by the batch job |
| IS_ACTIVE | CHAR | 1 | Flag indicating if the batch job is active. | |
| CRON_STRING | VARCHAR2 | 100 | Cron formatted scheduler string | |
| JOB_COMMAND_LABEL | VARCHAR2 | 50 | This is the name of the batch job. | |
| JOB_PARAMETERS | VARCHAR2 | 1000 | List of parameters for the batch job | |
| RETENTION | NUMBER | Yes | This is the number of days to retain a history. | |
| LOG_LEVEL | VARCHAR2 | 50 | Yes | Log level at which to run this job |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | |
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CSO_BATCH_JOBS_U1 | Unique | Default | RECORD_ID, ORA_SEED_SET1 |
| CSO_BATCH_JOBS_U11 | Unique | Default | RECORD_ID, ORA_SEED_SET2 |