You can monitor the runs and executions of a submitted job for a Managed Database or Database Group. A job execution is created for each of the Managed Databases associated with the job, and a job run is the sum of executions of a specific job that ran on a scheduled date.

To view the job runs and executions:

1. Go to the Managed database details or Database group details page.
2. On the left pane under Scope, ensure that the compartment in which the job was created is selected.
3. On the left pane under Resources, click Jobs.
4. In the Jobs section, click the Definitions tab and then click the name of the job. Alternatively, you can also click the corresponding Actions icon () and click View details.

The Job details page is displayed and it provides the details of the job, job runs and executions, and the associated Managed Databases on which the job is executed. On this page, you can perform tasks such as editing, moving, and deleting the job and using tags. In addition, you can also monitor each job execution and its status. To do so:

1. In the Job runs section, expand a job run, and click a job execution link.

   The job execution link is in the following format:

   <Name of job>_<Name of Managed Database>_YYYY-MM-DD'T'HH:MM:SS.SSS
2. On the Job execution details page, review the details such as the job execution status, the SQL associated with the execution, and the duration of the job execution. Note that the duration is the time taken for the entire job execution workflow to complete and not just the time taken for the SQL to execute on the database.
3. For a Query type job, click Download output to download the job execution output to a .txt file.
   Note
   
   The Download output option is only available for Query type jobs and you can use this option only if you have the required Oracle Cloud Infrastructure Object Storage service permissions. For more information, see Additional Permissions Required to Use Diagnostics & Management.