This is the situation:
I'm woriking on NT and there are two 8i databases on it
One database can execute jobs normally, but the other one not execute any
job.
I proved submitting the same procedure to both databases and worked on the
first one but not on the second one.
If I manually execute this:(On the database that have the problem):
Exec dbms_job.run(job_number);
Then the job is successful executed (without any error) and is programmed to the next interval but after that it�s not executed any more. And It doesn�t appear broken (I�ts like the queue process were not working).
I know all jobs are not executed because the column last_date on dba_jobs it�s not updated on any job (so next_date column it�s not updated) and the procedure of each job are not doing what they must do.
I�ts happens since one week ago and before that they were working well.
When I submit the Job I issued commit and I don�t receive any error message
So the Jobs doesn�t appear broken (I�ts like the queue process were not working)
But the initialization parameter are
job_queue_processes = 4
job_queue_interval = 10
in init_SID.ora file
So I repeat, the jobs were working well until one week ago, and I haven�t change nothing special on database.
the view dba_job_running appear empty all the time.
I removed all jobs and I recreated them again and it didn�t resolve the problem.
I�m not using Oracle Enterprise Management, so I can�t see diagnostic error messages and in the alert file it doesn�t appear nothing related with the jobs.
So early at morning I have to run the jobs manually
I�m thinking on shutdown down database but I want It to be the last option.
I hope you can help me
Thanks
Mauricio
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
