Oracle 10.2.0.4.0 EE on HP-UX 11.23
OEM (dbcontrol) is reporting 1 "broken" job and 2 "failed" jobs. Googling on fixing 'broken' jobs. A select on dba_jobs returns two rows. Following suggestions found elsewhere (mostly Burleson's site) I tried
SQL> select job from dba_jobs where broken='Y';
JOB
----------
50
51
2 rows selected.
SQL> exec dbms_job.broken(JOB=>50, NEXT_DATE=>SYSDATE+1/1440, BROKEN=>FALSE);
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> select job from dba_jobs where broken='Y';
JOB
----------
51
1 row selected.
wait a couple of minutes ....
SQL> /
JOB
----------
50
51
2 rows selected.
SQL> exec dbms_job.run(50);
BEGIN dbms_job.run(50); END;
*
ERROR at line 1:
ORA-12011: execution of 1 jobs failed
ORA-06512: at "SYS.DBMS_IJOB", line 413
ORA-06512: at "SYS.DBMS_JOB", line 275
ORA-06512: at line 1
SQL>
I keep running into dead ends on how to diagnose
why the job is failing ... pointers appreciated.