Answers for "dba scheduler jobs running"

SQL
4

dba_scheduler_jobs

SELECT OWNER, JOB_NAME, ENABLED, JOB_CLASS, NEXT_RUN_DATE
FROM DBA_SCHEDULER_JOBS
WHERE OWNER NOT IN ('SYS')
ORDER BY ENABLED, OWNER, JOB_NAME;

-- Running jobs:
SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_STYLE, SESSION_ID, SLAVE_PROCESS_ID, 
	ELAPSED_TIME, CPU_USED 
FROM DBA_SCHEDULER_RUNNING_JOBS
ORDER BY OWNER, JOB_NAME;
Posted by: Guest on July-26-2021
2

dba_scheduler_jobs history

SELECT LOG_DATE, OWNER, JOB_NAME, JOB_SUBNAME, STATUS,
       ACTUAL_START_DATE, RUN_DURATION, CPU_USED, ADDITIONAL_INFO
FROM ALL_SCHEDULER_JOB_RUN_DETAILS   	-- or DBA_SCHEDULER_JOB_RUN_DETAILS
WHERE JOB_NAME = 'job_name'
ORDER BY LOG_DATE DESC;
Posted by: Guest on July-26-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language