oracle list scheduled jobs

Solutions on MaxInterview for oracle list scheduled jobs by the best coders in the world

showing results for - "oracle list scheduled jobs"
Montserrat
30 Nov 2017
1select owner as schema_name,
2       job_name,
3       job_style,
4       case when job_type is null 
5                 then 'PROGRAM'
6            else job_type end as job_type,  
7       case when job_type is null
8                 then program_name
9                 else job_action end as job_action,
10       start_date,
11       case when repeat_interval is null
12            then schedule_name
13            else repeat_interval end as schedule,
14       last_start_date,
15       next_run_date,
16       state
17from sys.all_scheduler_jobs
18order by owner,
19         job_name;
20Code has been copied
Elias
04 Nov 2020
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;