Oracle教程 2023-02-23

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

ALL_SCHEDULER_DESTS视图是Oracle数据库中的数据字典视图，主要用于查看所有Scheduler调度程序创建的目标。

用法：

1. 查看所有oracle调度程序创建的目标：

select * from all_scheduler_dests;

2. 查看某个调度程序的所有目标：

select * from all_scheduler_dests where owner = ”;

ALL_SCHEDULER_DESTS displays information about the destination objects for jobs accessible to the current user.

Related Views

DBA_SCHEDULER_DESTS displays information about all destination objects for jobs in the database.
USER_SCHEDULER_DESTS displays information about the destination objects for jobs owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of this destination object
`DESTINATION_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of this destination object
`DESTINATION_TYPE`	`VARCHAR2(8)`		Type of this destination object: `EXTERNAL` `DATABASE`
`ENABLED`	`VARCHAR2(5)`		Indicates whether this destination object is enabled (`TRUE`) or disabled (`FALSE`)
`COMMENTS`	`VARCHAR2(4000)`		Optional comment