SELECT SID serial dbj JOB dbj schema_user to_char dbj last_date DD MM

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
SELECT
s.SID, s.serial#, dbj.JOB, dbj.schema_user,
to_char(dbj.last_date,'DD.MM.YYYY HH24:MI:SS')AS LAST,
to_char(dbj.next_date,'DD.MM.YYYY HH24:MI:SS')AS NEXT,
dbj.INTERVAL,
s.status,
s.action,
s.event,
s.state,
s.seconds_in_wait,
dbj.what
FROM dba_jobs_running dbr, dba_jobs dbj , v$session s
WHERE dbr.JOB = dbj.JOB AND s.SID = dbr.SID
ORDER BY dbj.schema_user, dbj.JOB;