本站中文解释
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_DESTSdisplays information about all destination objects for jobs in the database. -
USER_SCHEDULER_DESTSdisplays information about the destination objects for jobs owned by the current user. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of this destination object |
|
|
|
|
Name of this destination object |
|
|
|
Type of this destination object:
|
|
|
|
|
Indicates whether this destination object is enabled ( |
|
|
|
|
Optional comment |
See Also:
-
“DBA_SCHEDULER_DESTS”
-
“USER_SCHEDULER_DESTS”