1. Tables and Views for Common Features
  2. SBS_JOB_REQUESTS

SBS_JOB_REQUESTS

Job Scheduler stores job-related information into a database

Details

  • Schema: FUSION

  • Object owner: FND

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

SBS_JOB_REQUESTS_PK

JOB_REQUEST_ID

Columns

Name Datatype Length Precision Not-null Comments
JOB_REQUEST_ID NUMBER 18 Yes The identifier column for every job request submitted via the job scheduler
JOB_DEFINITION_NAME VARCHAR2 100 Yes Name of the job definition for this execution request
SPECTRA_SERVICE_NAME VARCHAR2 100 The spectra service that owns this job
JOB_DEFINITION_VERSION VARCHAR2 100 Version of the job definition
JOB_SUBMITTER VARCHAR2 128 Job request submitting user
JOB_RETRY_NUMBER NUMBER 9 Yes Job request retry number, starting from 0, which is increased by 1 for every subsequent retry attempt
LAST_ACTION_TIME TIMESTAMP Timestamp of last action
LAST_ACTION VARCHAR2 30 Last action name, e.g. 'ENQUEUE_REQUEST', 'ENQUEUE_CANCEL_REQUEST'
JOB_STATUS VARCHAR2 25 Yes This column displays the status of the job request. Valid values are Submitted, Waiting, Running, Successful, Failed, Cancelled
CANCEL_REQUEST_STATUS VARCHAR2 25 The status for tracking the progress in processing the cancellation request.
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
CLIENT_REQUEST_UUID VARCHAR2 64 Optional client-given unique identifier for the submitted request.
JOB_PAYLOAD BLOB Yes This column stores the attributes for Spectra Job submission that are part of the payload for Job request submission
JOB_PROGRESS BLOB This column store the near real-time progress information for the job request
TIMEOUT_THRESHOLD NUMBER 9 Yes Termination timeout threshold in seconds, which is used to automatically timeout and terminate a running job
TIMEOUT_DATE TIMESTAMP The timer set for the current state would expire after the given time
JOB_RETRY_POLICY BLOB The retry policy could include properties such as retryCount, retryInterval and backoffStrategy etc
REMAINING_RETRIES NUMBER 9 Number of retries yet to be performed. When it reaches 0, we are done with all retries
INPUT_FILES_READY VARCHAR2 1 Used to indicate that the input files for the job request are ready and the job execution can continue. Possible values are NULL, N, and Y
VISIBILITY_DATE TIMESTAMP The visibility flag used to support multiple consumers
PARENT_JOB_REQUEST_ID NUMBER 18 FK to the original job request
NEXT_SCHEDULED_TIME TIMESTAMP Scheduled time for running the next recurrence of a recurring job
SCHEDULE BLOB Stores the scheduling rules, which is a copy of the runAtTimes property from the request payload
LAST_RUN_SCHEDULED VARCHAR2 1 Indicates whether the last run per the recurring schedule has already been scheduled and there is no need to calculate NEXT_SCHEDULED_TIME any more
NEXT_SCHEDULED_TIMES BLOB Stores or caches a number of pre-calculated time slots for running the job for better performance
JOB_TITLE VARCHAR2 100 A brief title describing the job request for easier lookup and identification
JOB_DESCRIPTION VARCHAR2 4000 A detailed description or note providing additional context for the job request
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_REQUESTS_N1 Non Unique DEFAULT JOB_DEFINITION_NAME, SPECTRA_SERVICE_NAME, JOB_TITLE
SBS_JOB_REQUESTS_N2 Non Unique DEFAULT JOB_STATUS, LAST_ACTION, LAST_ACTION_TIME
SBS_JOB_REQUESTS_N3 Non Unique DEFAULT REMAINING_RETRIES
SBS_JOB_REQUESTS_N4 Non Unique DEFAULT PARENT_JOB_REQUEST_ID
SBS_JOB_REQUESTS_U1 Unique DEFAULT JOB_REQUEST_ID
SBS_JOB_REQUESTS_U2 Unique DEFAULT CLIENT_REQUEST_UUID