Visualizar JOBS no Oracle

Para visualizar os jobs pode-se utilizar a query abaixo:

SELECT JOB,
SUBSTR(WHAT,1,35),
NEXT_DATE,
NEXT_SEC,
BROKEN
FROM DBA_JOBS;


JOB SUBSTR(WHAT,1,35) NEXT_DATE NEXT_SEC B
---------- ----------------------------------- --------- -------- -
1 DBA.TESTE_001; 21-MAR-03 17:04:02 N
2 DBA.TESTE_002; 21-MAR-03 17:28:13 N
3 DBA.TESTE_003; 21-MAR-03 17:02:37 N
4 DBA.TESTE_004; 26-MAR-03 08:00:00 N