SBS_JOB_REQUESTS

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	64			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
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
SBS_JOB_REQUESTS_N2	Non Unique	DEFAULT	JOB_STATUS, LAST_ACTION, LAST_ACTION_TIME
SBS_JOB_REQUESTS_U1	Unique	DEFAULT	JOB_REQUEST_ID
SBS_JOB_REQUESTS_U2	Unique	DEFAULT	CLIENT_REQUEST_UUID