How to monitor currently running jobs in Oracle database? How to view the job details and the job related logs?
Amen Answered question 11/04/2023
We can monitor currently running jobs using the following SQL commands:
1 2 | SELECT job_name, session_id, running_instance, elapsed_time, FROM dba_scheduler_running_jobs; |
And to monitor the job run details:
1 | select * from DBA_SCHEDULER_JOB_RUN_DETAILS; |
And to view the job related logs:
1 | select * from DBA_SCHEDULER_JOB_LOG; |
Amen Answered question 11/04/2023