Thursday, March 24, 2011

How to check errors of 10g jobs

To check what happened with failed or stopped jobs in Oracle 10g:

SQL> column LOG_DATE format a40
SQL> column JOB_NAME format a20
SQL> column ADDITIONAL_INFO format a40
SQL> select LOG_ID, LOG_DATE, JOB_NAME, STATUS, ADDITIONAL_INFO from DBA_SCHEDULER_JOB_RUN_DETAILS
where STATUS in ('STOPPED','FAILED') order by LOG_DATE;


LOG_ID LOG_DATE JOB_NAME STATUS ADDITIONAL_INFO
------- ------------------------------------ ------------- -------- ----------------------------------------
6076 22-MAR-11 09.22.00.880338 PM -06:00 MY_JOB FAILED ORA-30036: unable to extend segment by O
RA-30036: unable to extend segment by 8
in undo tablespace 'UNDO'
ORA-06512: at "SYS.MY_PROCEDURE",
line 16
ORA-06512: at line 1
in undo tablespace ''

6085 23-MAR-11 09.22.00.608055 PM -06:00 MY_JOB FAILED ORA-30036: unable to extend segment by O
RA-30036: unable to extend segment by 8
in undo tablespace 'UNDO'
ORA-06512: at "SYS.MY_PROCEDURE",
line 16
ORA-06512: at line 1
in undo tablespace ''

6088 24-MAR-11 05.45.00.821410 AM -06:00 MY_OTHER_JOB STOPPED REASON="Stop job called"

No comments:

Post a Comment