DBA Hub

📋Steps in this guide1/1

Monitor scheduler jobs

-- Monitor currently running jobs

oracle configurationintermediate
by OracleDba
13 views
1

Monitor scheduler jobs

Code/Command (click line numbers to comment):

1
2
3
4
5
6
-- Monitor currently running jobs
SELECT job_name, session_id, running_instance, elapsed_time, FROM dba_scheduler_running_jobs;
-- View the job run details
select * from DBA_SCHEDULER_JOB_RUN_DETAILS;
-- View the job related logs:
select * from DBA_SCHEDULER_JOB_LOG;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!