Monitor scheduler jobs
-- Monitor currently running jobs
oracle configurationintermediate
by OracleDba
13 views
-- Monitor currently running jobs
123456
-- 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;Please to add comments
No comments yet. Be the first to comment!