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.DBA_SCHEDULER_JOB_ROLES

Object Details

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

All scheduler jobs in the database by database role

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the scheduler job
JOB_NAME	VARCHAR2	(128)	Yes	Name of the scheduler job
JOB_SUBNAME	VARCHAR2	(128)		Subname of the scheduler job (for a job running a chain step)
JOB_CREATOR	VARCHAR2	(128)
DATABASE_ROLE	VARCHAR2	(16)
PROGRAM_OWNER	VARCHAR2	(4000)		Owner of the program associated with the job
PROGRAM_NAME	VARCHAR2	(4000)		Name of the program associated with the job
JOB_TYPE	VARCHAR2	(16)		Inlined job action type
JOB_ACTION	VARCHAR2	(4000)		Inlined job action
JOB_CLASS	VARCHAR2	(128)		Name of job class associated with the job
SCHEDULE_OWNER	VARCHAR2	(4000)		Owner of the schedule that this job uses (can be a window or window group)
SCHEDULE_NAME	VARCHAR2	(4000)		Name of the schedule that this job uses (can be a window or window group)
SCHEDULE_TYPE	VARCHAR2	(12)		Type of the schedule that this job uses
START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Original scheduled start date of this job (for an inlined schedule)
REPEAT_INTERVAL	VARCHAR2	(4000)		Inlined schedule PL/SQL expression or calendar string
END_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		Date after which this job will no longer run (for an inlined schedule)
LAST_START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)
ENABLED	VARCHAR2	(5)		Whether the job is enabled
STATE	VARCHAR2	(15)		Current state of the job
COMMENTS	VARCHAR2	(240)		Comments on the job

Query Text

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


SELECT OWNER
,      JOB_NAME
,      JOB_SUBNAME
,      JOB_CREATOR
,      DATABASE_ROLE
,      PROGRAM_OWNER
,      PROGRAM_NAME
,      JOB_TYPE
,      JOB_ACTION
,      JOB_CLASS
,      SCHEDULE_OWNER
,      SCHEDULE_NAME
,      SCHEDULE_TYPE
,      START_DATE
,      REPEAT_INTERVAL
,      END_DATE
,      LAST_START_DATE
,      ENABLED
,      STATE
,      COMMENTS
FROM SYS.DBA_SCHEDULER_JOB_ROLES;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_JOB_ROLES references the following:

SYS: OBJ$; SCHEDULER$_JOB; USER$

SYS.DBA_SCHEDULER_JOB_ROLES is referenced by following:

PUBLIC: DBA_SCHEDULER_JOB_ROLES