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;