Posted By

thescorpion on 10/20/12


Tagged

sql Oracle PLSQL DBA


Versions (?)

Mostrar JOB


 / Published in: SQL
 

mostar los job registrados en oracle

  1. SELECT job, substr(SCHEMA_USER,1,12) schema,
  2. substr(TO_CHAR(NEXT_DATE,'DAY DD-MON-YY'),1,19) Next_Day,
  3. NEXT_SEC, BROKEN b,
  4. FAILURES fail, substr(what,1,100) what,
  5. decode(SUBSTR(INTERVAL,30,30),NULL,SUBSTR(INTERVAL,1,30),
  6. SUBSTR(INTERVAL,30,30)) INTERVAL
  7. FROM dba_jobs
  8. ORDER BY NEXT_DATE, NEXT_SEC

Report this snippet  

You need to login to post a comment.