oracle job schedules

Solutions on MaxInterview for oracle job schedules by the best coders in the world

showing results for - "oracle job schedules"
Domenico
21 Feb 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;
Christopher
25 Jul 2018
1SELECT OWNER,
2       SCHEDULE_NAME,
3       START_DATE,
4       REPEAT_INTERVAL,
5       END_DATE,
6       COMMENTS
7FROM DBA_SCHEDULER_SCHEDULES
8ORDER BY OWNER, SCHEDULE_NAME;