Home > SQL Developer Dialog Boxes ... > Start Date, End Date, Repea...
Dialog boxes are available for specifying start and end dates, a repeat interval, and optional comments for an Oracle Scheduler job. For more information about job scheduling, see Scheduling Jobs Using SQL Developer.
Start Date, End Date
For Start Date and End Date, specify the date and time, or click Set Today to specify the current date and time.
Tabs are provided for Frequency and various refinements of the frequency. Use as many as you need for specifying when to run the job.
Repeat Interval
Frequency tab: Specify a frequency for the job (such as DAILY or WEEKLY),
Other tabs (most in the form "By xxxxx"): Select (check) Enable to be able to specify the value or values relevant to that frequency category.
A box at the bottom displays the keywords and values for the statement that SQL Developer will use to call the DBMS_SCHEDULER.CREATE_SCHEDULE procedure.
Comments
Optional descriptive comment about the scheduler object.
Related Topics