Database Administration (MOSC)

MOSC Banner

dba_scheduler_jobs "jobs that still running", "jobs that has been late"

edited Aug 25, 2016 5:00AM in Database Administration (MOSC) 2 commentsAnswered

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_200:00:02SCHEDULED
Fail_100:00:02SCHEDULED
Overdue_200:00:02SCHEDULED
Job_Fail100:00:02BROKEN
Overdue_100:00:02SCHEDULED
Job_New00:00:02SCHEDULED
Job_Fail00:00:02DISABLED
Long_100:02:30SCHEDULED

Please help me to get output for "jobs that still running", "jobs that has been late by 2 min"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center