eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.USER_SCHEDULER_JOB_ARGS

Object Details

Object Name:	USER_SCHEDULER_JOB_ARGS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

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

[View Source]

Columns

Name	Datatype	Length	Comments
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	(257)	Data type of this argument
VALUE	VARCHAR2	(4000)	Value set to this argument in string format (if a string)
ANYDATA_VALUE	ANYDATA	(64)	Value set to this argument in AnyData format
OUT_ARGUMENT	VARCHAR2	(5)	Reserved for future use

Query Text

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


SELECT JOB_NAME
,      ARGUMENT_NAME
,      ARGUMENT_POSITION
,      ARGUMENT_TYPE
,      VALUE
,      ANYDATA_VALUE
,      OUT_ARGUMENT
FROM SYS.USER_SCHEDULER_JOB_ARGS;

Dependencies

[top of page]

SYS.USER_SCHEDULER_JOB_ARGS references the following:

SYS: ANYDATA; DBMS_SCHEDULER - show dependent code; OBJ$; SCHEDULER$_COMB_LW_JOB; SCHEDULER$_JOB; SCHEDULER$_JOB_ARGUMENT; SCHEDULER$_LWJOB_OBJ; SCHEDULER$_PROGRAM_ARGUMENT; STANDARD - show dependent code; USER$

SYS.USER_SCHEDULER_JOB_ARGS is referenced by following:

PUBLIC: USER_SCHEDULER_JOB_ARGS