7 The Scheduling Pages

Note:

Available for Oracle Database 12c release 2 and later releases.

Database Actions provides a graphical interface for using the DBMS_SCHEDULER PL/SQL package to work with Oracle Scheduler objects such as Jobs, Chains, Programs and Schedules. To use the 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 the Oracle Database Administrator's Guide.

The Scheduling functionality is focused on exploring Oracle Database Scheduler artifacts and provides details for jobs, chains, chain steps and rules, job execution history, programs, schedules, job classes, file watchers, windows and window groups. Depending on the access rights of the logged-in user, information is taken from ALL_* or DBA_* views.

Note:

SQL and PL/SQL editors are used in the user interfaces for Jobs and Programs. Some shortcut keys used in these editors are:

  • Alt+F1: Invokes accessibility options.
  • Ctrl+M: Alters the Tab key behavior, from inserting tab to going to the next control on the form.

    For more keyboard shortcuts, see Keyboard Shortcuts.

To navigate to the Scheduling pages, do either of the following:

  • In the Launchpad page, select the Development tab and click Scheduling.

  • Click Selectorselector iconto display the navigation menu. Under Development, select Scheduling.