Jobs – useful queries

  • show running jobs:
    select jf.sid,
           jf.job,
           jf.FAILURES,
           jf.LAST_DATE,
           jf.THIS_DATE,
           j.LOG_USER,
           j.interval,
           j.what
      from dba_jobs_running jf, dba_jobs j
     where jf.job = j.JOB(+)
    

Leave a Reply

Your email address will not be published. Required fields are marked *