oracle jobs run log

To view the Oracle jobs run log, you can check the job history in the Oracle database. Here are the steps to do so:

1. Connect to the Oracle database using a client tool like SQL*Plus or SQL Developer.
2. Run the following query to retrieve the job history:

   SELECT job_name, log_date, status, error#, additional_info
   FROM dba_scheduler_job_run_details
   ORDER BY log_date DESC;

This query will return the job name, log date, status, error number, and additional information for each job run.

3. Analyze the results to identify the specific job runs you are interested in. The status column will indicate whether the job succeeded or failed.

Please note that you need appropriate privileges (e.g., SELECT_CATALOG_ROLE) to access the DBA_SCHEDULER_JOB_RUN_DETAILS view. Additionally, you may need to modify the query to filter results based on specific criteria, such as a particular job name or date range.