本站中文解释
Oracle 视图 DBA_SCHEDULER_EXTERNAL_DESTS 是 Oracle 数据库调度器管理器（DBMS_SCHEDULER）中定义的一个数据字典视图，它显示所有外部调度目标的信息。这个视图允许 DBA 确定目标是否已成功创建，以及确定外部调度目标的相关属性。
使用方法：
1.查看所有外部调度对象：
SELECT owner_name,dest_name, address, port, login_type, db_name, is_reachable FROM dba_scheduler_external_dests;
2.查看指定名称的外部调度对象：
SELECT owner_name, dest_name, address, port, login_type, db_name, is_reachable FROM dba_scheduler_external_dests WHERE dest_name=’DEST_NAME’;
3.确定外部调度目标是否可以到达：
SELECT dest_name, is_reachable FROM dba_scheduler_external_dests WHERE dest_name=’DEST_NAME’;
4.查看外部调度目标的相关属性：
SELECT owner_name, dest_name, address, port, login_type, db_name, is_reachable FROM dba_scheduler_external_dests WHERE dest_name=’DEST_NAME’;
官方英文解释
DBA_SCHEDULER_EXTERNAL_DESTS displays information about all destination objects in the database pointing to remote agents. Its columns are the same as those in ALL_SCHEDULER_EXTERNAL_DESTS.
See Also:
“ALL_SCHEDULER_EXTERNAL_DESTS”
