Create/Edit Schedule

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

(To create a schedule, SQL Developer internally uses the DBMS_SCHEDULER.CREATE_SCHEDULE procedure.)

Properties

Name: Name of the schedule. The name has to be unique in the SQL namespace. For example, a schedule cannot have the same name as a table in a schema.

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

When: Specify when jobs that use this schedule are to run: Repeating (specify the repeat interval), Queue (specify the queue name), or File Watcher (specify the file watcher object name).

SQL

Displays the DBMS_SCHEDULER.CREATE_SCHEDULE procedure that will be used to create the schedule according to your specifications.

Related Topics

Programs

Scheduling Jobs Using SQL Developer