Oracle教程 2023-02-23

Oracle 视图 ALL_SCHEDULER_SCHEDULES 官方解释，作用，如何使用详细说明

视图

Oracle存储数据库安全信息的视图之一是ALL_SCHEDULER_SCHEDULES，它提供对数据库内部定义的作业调度方案或用户定义的作业调度方案的信息报告。

该视图可用于检索已授权作业调度器的信息。这可以帮助用户识别数据库内的作业调度，以便在作业调度需要改变时进行必要的管理。

使用该视图需要具有SELECT_CATALOG_ROLE权限，可以阻止没有必要的对调度程序的访问权限的用户检索此信息。

在Oracle中，可以使用以下语句来访问ALL_SCHEDULER_SCHEDULES视图：

SELECT SCHEDULE_NAME, ENABLED, AUTO_DROP, REPEAT_INTERVAL, END_DATE
FROM all_scheduler_schedules;

ALL_SCHEDULER_SCHEDULES displays information about the Scheduler schedules accessible to the current user.

Related Views

DBA_SCHEDULER_SCHEDULES displays information about all Scheduler schedules in the database.
USER_SCHEDULER_SCHEDULES displays information about the Scheduler schedules owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the schedule
`SCHEDULE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the schedule
`SCHEDULE_TYPE`	`VARCHAR2(12)`		Type of the schedule: `ONCE` – Repeat interval is NULL `CALENDAR` – Oracle calendaring expression used as schedule `EVENT` – Event schedule
`START_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Start date for the repeat interval
`REPEAT_INTERVAL`	`VARCHAR2(4000)`		Calendar syntax expression for the schedule
`EVENT_QUEUE_OWNER`	`VARCHAR2(128)`		Owner of the source queue into which the event will be raised
`EVENT_QUEUE_NAME`	`VARCHAR2(128)`		Name of the source queue into which the event will be raised
`EVENT_QUEUE_AGENT`	`VARCHAR2(523)`		Name of the AQ agent used by the user on the event source queue (if it is a secure queue)
`EVENT_CONDITION`	`VARCHAR2(4000)`		Boolean expression used as the subscription rule for the event on the source queue
`FILE_WATCHER_OWNER`	`VARCHAR2(261)`		Owner of the file watcher on which this schedule is based
`FILE_WATCHER_NAME`	`VARCHAR2(261)`		Name of the file watcher on which this schedule is based
`END_DATE`	`TIMESTAMP(6) WITH TIME ZONE`		Cutoff date after which the schedule will not specify any dates
`COMMENTS`	`VARCHAR2(4000)`		Comments on the schedule