Create/Edit Database Destination

This interface is used for creating or editing an Oracle Scheduler database destination. For more information about job scheduling, see Scheduling Jobs Using SQL Developer.

(To create a database destination, SQL Developer internally uses the DBMS_SCHEDULER.CREATE_DATABASE_DESTINATION procedure.)

Name: Name of the database destination. It can optionally be prefixed with a schema name. Cannot be null. It is converted to uppercase unless enclosed in double-quotes.

Enabled: Enables the database destination. (Causes the DBMS_SCHEDULER.ENABLE procedure to be called after the database destination is created.)

Description: Optional text string that can be used to describe the database destination.

Connection Info: An Oracle Net connect identifier that is resolved to the Oracle database instance being connected to.

Agent: The external destination name of the Scheduler agent to connect. Equivalent to an agent name.

Related Topics

Database Destinations

Scheduling Jobs Using SQL Developer