| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03  | 
  | 
  | 
PDF · Mobi · ePub | 
ALL_SCHEDULER_DESTS displays information about the destination objects for jobs accessible to the current user.
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(30) | 
NOT NULL | 
Owner of this destination object | 
DESTINATION_NAME | 
VARCHAR2(30) | 
NOT NULL | 
Name of this destination object | 
DESTINATION_TYPE | 
VARCHAR2(8) | 
Type of this destination object:
  | 
|
ENABLED | 
VARCHAR2(5) | 
Indicates whether this destination object is enabled (TRUE) or disabled (FALSE) | 
|
COMMENTS | 
VARCHAR2(240) | 
Optional comment | 
See Also: