Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


ALL_SCHEDULER_EXTERNAL_DESTS displays information about the destination objects accessible to the current user pointing to remote agents.

Related View

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