This content has been marked as final. Show 10 replies
When a job fails it is automatically re-executed. This is repeated 16 times. After 16 times it is marked as 'broken'.
Dba_jobs will show which jobs are broken.
The dbms_job.broken procedure can unmark them as broken.
All of this, of course, is documented.
Senior Oracle DBA
Well, I have checked when the jobs supposed to runned and none message was alerted.
The jobs are working, they were runned automatically before. I think the problem is in execute them at the time I seted.
Result from dba_jobs:
As you can see, the job didn't run at 18/05/13
I'm sorry for all this mess! The other guy who work with me changed the value of job_queue_processes to 0 and didn't tell me. At morning I was changing the value to 100 and at night, when the jobs are supposed to run, he changed back to 0. It was a communication failure.
Thanks for all your tips!