SBS_JOB_CONCURRENCY

Details

Name	Columns
SBS_JOB_CONCURRENCY_PK	JOB_CONCURRENCY_ID

Name	Datatype	Length	Precision	Not-null	Comments
JOB_CONCURRENCY_ID	NUMBER		18	Yes	System-generated PK for every job concurrency control record
NAME	VARCHAR2	150		Yes	Name of the job concurrency control
DESCRIPTION	VARCHAR2	4000			Description of the job concurrency control
JOB_DEFINITION_NAME	VARCHAR2	100		Yes	Name of the job definition for this execution request
SPECTRA_SERVICE_NAME	VARCHAR2	100		Yes	The spectra service that owns the job definition
SCOPE	VARCHAR2	30		Yes	Scope of the job concurrency control, either 'GLOBAL' or 'DOMAIN'
SCOPE_VALUE_EXPR	VARCHAR2	2000		Yes	The expression used to derive the specific scope value of the job concurrency control
CONCURRENCY_LIMIT	NUMBER		9	Yes	The maximum number of concurrent job requests allowed
VERSION_TAGS	VARCHAR2	2000		Yes	List of version numbers or deployment identifiers associated with a job definition
DEFAULT_FLAG	VARCHAR2	1		Yes	Indicator for being the default version
DELETED_FLAG	VARCHAR2	1		Yes	Indicator for soft-deleted record
IS_SEEDED	VARCHAR2	1		Yes	Indicator whether the job concurrency control is seeded or not
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.

Index	Uniqueness	Tablespace	Columns
SBS_JOB_CONCURRENCY_U1	Unique	DEFAULT	JOB_CONCURRENCY_ID
SBS_JOB_CONCURRENCY_U2	Unique	DEFAULT	NAME, STANDARD_HASH("VERSION_TAGS")
SBS_JOB_CONCURRENCY_U3	Unique	DEFAULT	JOB_DEFINITION_NAME, SPECTRA_SERVICE_NAME, SCOPE, STANDARD_HASH("SCOPE_VALUE_EXPR"), STANDARD_HASH("VERSION_TAGS")