Monitor scheduler jobs - Oracle Database Script. -- 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;
-- 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;