How to monitor currently running jobs

Question

737 views11/04/2023Oracle Database

0

Ezana886 08/04/2023 0 Comments

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

Write your answer.

score 0 · Answer 1 · 2023-04-11T18:22:23+00:00

We can monitor currently running jobs using the following SQL commands:

SELECT job_name, session_id, running_instance, elapsed_time, 
  FROM dba_scheduler_running_jobs;

And to monitor the job run details:

select * from DBA_SCHEDULER_JOB_RUN_DETAILS;

And to view the job related logs:

select * from DBA_SCHEDULER_JOB_LOG;