SBS_JOB_EXECUTIONS
Job manager table
Details
-
Schema: FUSION
-
Object owner: FND
-
Object type: TABLE
-
Tablespace: TRANSACTION_TABLES
Primary Key
| Name | Columns |
|---|---|
|
SBS_JOB_EXECUTIONS_PK |
JOB_EXECUTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| JOB_EXECUTION_ID | NUMBER | 18 | Yes | The identifier column for every job request execution | |
| JOB_REQUEST_ID | NUMBER | 18 | Yes | Foreign key reference to job requests identifier column | |
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Yes | Name of the job definition for this execution request | |
| JOB_STATUS | VARCHAR2 | 25 | Yes | This column displays the status of the job execution. Valid values are Running, Successful, Failed, Cancelled | |
| CANCEL_REQUEST_STATUS | VARCHAR2 | 25 | The status for processing the cancellation request | ||
| JOB_EXECUTION_CONTEXT | BLOB | To store the job execution context such as a job request and etc. | |||
| JOB_RETRY_NUMBER | NUMBER | 9 | Yes | Job request retry number, starting from 0, which is increased by 1 for every subsequent retry attempt | |
| START_TIME | TIMESTAMP | Actual start time of the job | |||
| END_TIME | TIMESTAMP | Actual end time of the job | |||
| TIMEOUT_THRESHOLD | NUMBER | 9 | Yes | Termination timeout threshold (in seconds), which is used to automatically timeout and terminate a running job | |
| ARRAY_JOB_PARENT_ID | NUMBER | 18 | ID of the parent execution record that represents the overall array job. | ||
| ARRAY_JOB_INSTANCE_INDEX | NUMBER | 9 | -2 for manager container running in PRE-PROCESSING mode, -1 for manager container running in POST-PROCESSING mode, 0 for first worker instance, 1 for second worker instance, etc., NULL in all other cases. | ||
| RETRY_COUNT | NUMBER | 2 | To store retry count for a single execution, each execution is for a given job retry count | ||
| IS_PREEMPTION_ALLOWED | VARCHAR2 | 1 | Yes | Indicates whether the job can be preemptively terminated after it is already running | |
| SCHEDULING_URGENCY | VARCHAR2 | 30 | Yes | The level of scheduling urgency for the job, e.g. NORMAL, TIME_SENSITIVE, TIME_INSENSITIVE | |
| DELAY_TOLERANCE_THRESHOLD | NUMBER | 9 | Yes | The amount of execution delay in seconds that the job can tolerate | |
| SCHEDULED_TIME | TIMESTAMP | The time at which the job is scheduled to run | |||
| JOB_RESOURCE_RELEASED | VARCHAR2 | 1 | Indicate whether the job resources are released. Possible values are NULL, N, Y | ||
| LAST_PUBLISHED_STATUS | VARCHAR2 | 25 | Tracks the last status published for Job Scheduler to consume | ||
| TIMEOUT_DATE | TIMESTAMP | The timer set for the current state would expire after the given time | |||
| VISIBILITY_DATE | TIMESTAMP | The visibility flag used to support multiple consumers | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| SBS_JOB_EXECUTIONS_N1 | Non Unique | DEFAULT | JOB_STATUS |
| SBS_JOB_EXECUTIONS_N2 | Non Unique | DEFAULT | JOB_REQUEST_ID |
| SBS_JOB_EXECUTIONS_N3 | Non Unique | DEFAULT | ARRAY_JOB_PARENT_ID |
| SBS_JOB_EXECUTIONS_N4 | Non Unique | DEFAULT | JOB_RESOURCE_RELEASED |
| SBS_JOB_EXECUTIONS_N5 | Non Unique | DEFAULT | LAST_PUBLISHED_STATUS |
| SBS_JOB_EXECUTIONS_U1 | Unique | DEFAULT | JOB_EXECUTION_ID |