本站中文解释

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

See Also:

• “DBA_SCHEDULER_DESTS”

• “USER_SCHEDULER_DESTS”

---

编辑：一起学习网

标签：目标,程序,视图,英文,主要用于