Home > SQL Developer Concepts and ... > Scheduling Jobs Using SQL D...
SQL Developer provides a graphical interface for using the DBMS_SCHEDULER PL/SQL package to work with Oracle Scheduler objects. To use the SQL Developer scheduling features, you must first understand the concepts and essential tasks for job scheduling, which are explained in the chapters about Oracle Scheduler concepts and scheduling jobs in Oracle Database Administrator's Guide.
The Scheduler node for a connection appears in the Connections navigator and in the DBA navigator. The DBA navigator displays Scheduler objects owned by the SYS user and requiring DBA privileges for creating and modifying; the Connections navigator displays other Scheduler objects that may require specific privileges for creating and modifying. The Oracle Scheduler objects are grouped under object types that include:
You can right-click an item (node) at any level in the Scheduler hierarchy to display a context menu with commands relevant to that item. Typical commands include the following:
New [object-type] enables you to create a new object of that type.
Refresh queries the database for the current details about the selected object (for example, a connection or just a table).
Apply Filter restricts the display of objects using a filter that you specify. To remove the effects of applying a filter, right-click the node and select Clear Filter.
Open displays a pane with relevant information on the right side of the window. The pane may be read-only or editable.
Help displays a brief definition or description of objects of that type.
Drop (with an object selected) drops (deletes) the object.
Create Like (with an object selected) creates an object of that type using information from the selected object. You must specify a name for the newly created object, and you can change other properties as needed.
If you right-click the top-level Scheduler node, you can create an object of a specified type, and you can display the Scheduler Design Editor.
The pane with information about an item opened from the Scheduler hierarchy typically contains icons and other controls for the following:
Freeze View (the pin) keeps that object's tab and information in the window when you click another object in the Connections navigator; a separate tab and display are created for that other object. If you click the pin again, the object's display is available for reuse.
Run updates the display by querying the database for the latest information.
Refresh lets you select an interval for automatically updating the display.
Actions displays a menu with actions appropriate for the object. For example, the actions for a job include New Job, Drop, Run Job Now, and Create Like.
With information displays that are in grid form, you can often use the context (right-click) menu on a header or a data cell to perform operations like those for the table data grid, as explained in Entering and Modifying Data. For example, right-clicking on a header lets you select options like Auto-fit, Columns, Sort, Delete Persisted Settings (such as any sort order specifications), and Filter Column; right-clicking any data cell lets you select options like Save Grid as Report, Single-Record View, Count Rows, Find/Highlight (find and optionally highlight values in the grid), and Export (unload data).
Several Scheduler reports are also available.
The scheduler design editor is a graphical interface for Scheduling Jobs Using SQL Developer. To create, edit, or delete any Oracle Scheduler objects in the editor, you must be in write mode. You can use the editor toolbar toggle button or the right-click command to Switch to write mode and Switch to read-only mode.
To copy existing objects to the schedule design editor, drag the objects from the Connections navigator onto the editing canvas.
To create a new object, right-click in the canvas and select the context menu command for creating a new object of the desired type.
To open an object, double-click it or right-click it and select Open.
To delete an object, right-click it and select Drop. You will be prompted to confirm that you want to drop the object.
To remove the object from the editing canvas without deleting the object itself, right-click it and select Clear.
To enable a disabled object, right-click it and select Enable; to disable an enabled object, right-click it and select Disable.
You can click, drag, and release to set a relationship between compatible objects. For example, to set a schedule for a job, you can drag the schedule onto the job, which causes a line to be drawn between the objects. You can unset (remove) that relationship by right-clicking the line and selecting the appropriate command (such as Unset Schedule), and then clicking OK when you are prompted to confirm the action.