dba scheduler jobs

Solutions on MaxInterview for dba scheduler jobs by the best coders in the world

showing results for - "dba scheduler jobs"
Felix
02 Oct 2017
1SELECT OWNER, JOB_NAME, ENABLED, JOB_CLASS, NEXT_RUN_DATE
2FROM DBA_SCHEDULER_JOBS
3WHERE OWNER NOT IN ('SYS')
4ORDER BY ENABLED, OWNER, JOB_NAME;
5
6-- Running jobs:
7SELECT OWNER, JOB_NAME, JOB_SUBNAME, JOB_STYLE, SESSION_ID, SLAVE_PROCESS_ID, 
8	ELAPSED_TIME, CPU_USED 
9FROM DBA_SCHEDULER_RUNNING_JOBS
10ORDER BY OWNER, JOB_NAME;
Luka
23 Nov 2018
1SELECT LOG_DATE, OWNER, JOB_NAME, JOB_SUBNAME, STATUS,
2       ACTUAL_START_DATE, RUN_DURATION, CPU_USED, ADDITIONAL_INFO
3FROM ALL_SCHEDULER_JOB_RUN_DETAILS   	-- or DBA_SCHEDULER_JOB_RUN_DETAILS
4WHERE JOB_NAME = 'job_name'
5ORDER BY LOG_DATE DESC;