DBA Data[Home] [Help] [Dependency Information]


VIEW: SYS.CDB_SCHEDULER_JOB_ARGS

Object Details
Object Name: CDB_SCHEDULER_JOB_ARGS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All arguments with set values of all scheduler jobs in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30)
Owner of the job this argument belongs to
JOB_NAME VARCHAR2 (128)
Name of the job this argument belongs to
ARGUMENT_NAME VARCHAR2 (128)
Optional name of this argument
ARGUMENT_POSITION NUMBER

Position of this argument in the argument list
ARGUMENT_TYPE VARCHAR2 (61)
Data type of this argument
VALUE VARCHAR2 (4000)
Value set to this argument in string format (if a string)
ANYDATA_VALUE ANYDATA (80)
Value set to this argument in AnyData format
OUT_ARGUMENT VARCHAR2 (5)
Reserved for future use
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      JOB_NAME
,      ARGUMENT_NAME
,      ARGUMENT_POSITION
,      ARGUMENT_TYPE
,      VALUE
,      ANYDATA_VALUE
,      OUT_ARGUMENT
,      CON_ID
FROM SYS.CDB_SCHEDULER_JOB_ARGS;

Dependencies

[top of page]

SYS.CDB_SCHEDULER_JOB_ARGS references the following:

SchemaSYS
TYPEANYDATA
PL/SQL PackageSTANDARD - show dependent code
SYS.CDB_SCHEDULER_JOB_ARGS is referenced by following:

SchemaPUBLIC
SynonymCDB_SCHEDULER_JOB_ARGS