Create and Monitor Jobs

A job is an Oracle Cloud Infrastructure resource that enables you to create and asynchronously execute SQL jobs on a single Managed Database or all the Managed Databases in a Database Group.

Before you create a job and monitor its runs and executions, you must:

  • Review and complete the tasks given in Get Started. Note that to create Query type jobs, you must have additional Oracle Cloud Infrastructure Object Storage service permissions. For information, see Additional Permissions Required to Use Database Management.
  • Create a Database Group, if you want to create a job for all the databases in the Database Group.

To go to the Jobs section:

  1. Sign in to the Oracle Cloud Infrastructure console.
  2. Open the navigation menu, click Observability & Management. Under Database Management, click Overview.
  3. Depending on whether you want to create a job for a single Managed Database or a Database Group, go to one of the following Database Management pages:
  4. On the left pane under Resources, click Jobs.

The following tabs are displayed in the Jobs section:

  • Definitions: On this tab, you can create a job and view the jobs that are in the Active state and were created within the time period selected in the Time period field.
  • Runs: On this tab, you can monitor job runs and executions.