delete

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(+)