dba_scheduler_jobs "jobs that still running", "jobs that has been late"
Hi All,
I am using below query to identify
select JOB_NAME, to_char(extract(hour from od.LAST_RUN_DURATION),'FM09')||':'|| to_char(extract(minute from od.LAST_RUN_DURATION),'FM09')
||':'|| to_char(extract(second from od.LAST_RUN_DURATION),'FM09') hhmiss,STATE from dba_scheduler_jobs od where LAST_RUN_DURATION is not null;
Fail_2 | 00:00:02 | SCHEDULED |
Fail_1 | 00:00:02 | SCHEDULED |
Overdue_2 | 00:00:02 | SCHEDULED |
Job_Fail1 | 00:00:02 | BROKEN |
Overdue_1 | 00:00:02 | SCHEDULED |
Job_New | 00:00:02 | SCHEDULED |
Job_Fail | 00:00:02 | DISABLED |
Long_1 | 00:02:30 | SCHEDULED |
Please help me to get output for "jobs that still running", "jobs that has been late by 2 min"