DBA Hub

📋Steps in this guide1/1

history of all scheduler job runs

set pagesize 299 set lines 299 col JOB_NAME for a24 col actual_start_date for a56 col RUN_DURATION for a34 select job_name,status,actual_start_date,run_duration from DBA_SCHEDULER_JOB_RUN_DETAILS order by ACTUAL_START_DATE desc;

oracle configurationintermediate
by OracleDba
11 views
1

history of all scheduler job runs

Code/Command (click line numbers to comment):

1
2
3
4
5
6
set pagesize 299
set lines 299
col JOB_NAME for a24
col actual_start_date for a56
col RUN_DURATION for a34
select job_name,status,actual_start_date,run_duration from DBA_SCHEDULER_JOB_RUN_DETAILS order by ACTUAL_START_DATE desc;

Comments (0)

Please to add comments

No comments yet. Be the first to comment!