ALL_SCHEDULER_GROUPS

ALL_SCHEDULER_GROUPS displays information about the Scheduler object groups accessible to the current user.

Related Views

DBA_SCHEDULER_GROUPS displays information about all Scheduler object groups in the database.
USER_SCHEDULER_GROUPS displays information about the Scheduler object groups owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Owner of the group
`GROUP_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the group
`GROUP_TYPE`	`VARCHAR2(13)`		Type of object contained in the group: `WINDOW` `JOB` `DB_DEST` `EXTERNAL_DEST`
`ENABLED`	`VARCHAR2(5)`		Indicates whether the group is enabled (`TRUE`) or disabled (`FALSE`)
`NUMBER_OF_MEMBERS`	`NUMBER`		Number of members in this group
`COMMENTS`	`VARCHAR2(240)`		An optional comment about this group