Calışan job lar

Çalışan job listesi

SELECT c.username kullanici,c.machine bilgisayar,
c.program program,
b.what islem,
a.sid,
c.serial#,
a.job,
a.failures hata,
to_char(a.this_date,
'mm/dd/yyyy hh24:mi')isleme_baslama,
ROUND((SYSDATE-a.this_date)*24*60,2) calisma_suresi_dakikaFROM dba_jobs_running a,dba_jobs b,
v$session c
WHERE a.job = b.jobAND a.sid = c.sidORDER BY a.this_date
Not : Faruk Hocam a teşekkürler