| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
ALL_SCHEDULER_EXTERNAL_DESTS displays information about the destination objects accessible to the current user pointing to remote agents.
DBA_SCHEDULER_EXTERNAL_DESTS displays information about all destination objects in the database pointing to remote agents.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
| DESTINATION_NAME | VARCHAR2(30) | NOT NULL | Name of this destination object | 
| HOSTNAME | VARCHAR2(256) | Name or IP address of the host on which the agent is located | |
| PORT | NUMBER | Port that the agent is listening on | |
| IP_ADDRESS | VARCHAR2(64) | IP address of the host on which the agent is located | |
| ENABLED | VARCHAR2(5) | Indicates whether this destination object is enabled ( TRUE) or disabled (FALSE) | |
| COMMENTS | VARCHAR2(240) | Optional comment | 
See Also:
"DBA_SCHEDULER_EXTERNAL_DESTS"