I have some jobs to execute in dbms_job, last week all of them runned automatically based on the interval I have seted, but they aren't running anymore, I don't know to say why.
If I try to run them manually they run ok.
What can I do for they runly automatically?
I already take a look at job_queue, it seens that the problem isn't there.
show parameter job_queue
NAME TYPE VALUE
job_queue_processes integer 100
Db version: Oracle9i Enterprise Edition Release 126.96.36.199.0
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.
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.