advanced code snippet search

Posted By

thescorpion on 10/20/12


Tagged

sql Oracle PLSQL DBA


Versions (?)

Mostrar JOB

 / Published in: SQL
 

mostar los job registrados en oracle

Expand | Embed | Plain Text 
  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.