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

VIEW: SYS.ALL_SCHEDULER_GROUPS

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

All scheduler object groups visible to current user

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the group
GROUP_NAME VARCHAR2 (128) Yes Name of the group
GROUP_TYPE VARCHAR2 (13)
Type of object contained in the group
ENABLED VARCHAR2 (5)
Whether the group is enabled
NUMBER_OF_MEMBERS NUMBER

Number of members in this group
COMMENTS VARCHAR2 (240)
An optional comment about this group
Query Text

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


SELECT OWNER
,      GROUP_NAME
,      GROUP_TYPE
,      ENABLED
,      NUMBER_OF_MEMBERS
,      COMMENTS
FROM SYS.ALL_SCHEDULER_GROUPS;

Dependencies

[top of page]

SYS.ALL_SCHEDULER_GROUPS references the following:

SchemaSYS
ViewALL_SCHEDULER_GROUP_MEMBERS
TableOBJ$
TableOBJAUTH$
TableSCHEDULER$_WINDOW_GROUP
TableUSER$
SYS.ALL_SCHEDULER_GROUPS is referenced by following:

SchemaPUBLIC
SynonymALL_SCHEDULER_GROUPS
SchemaSYS
ProcedureDBMS_FEATURE_JOB_SCHEDULER - show dependent code