Hi Gurus,

I have a scheduled database job which runs each night. This job runs for couple of days without any problem and does not work after few days.
I can execute the job manually without any problem but the database doesn't execute it automatically when it get stuck. When this happens, if I bounce the database it starts to work again for couple of days and then stops again.
I have checked the alert log but no error or warning messages even when it is not working.
This job runs on a 9.2 database. Any help/advise will be greatly appreciated.
Disclaimer:

This e-mail is confidential to the addressee and is the view of the writer, not necessarily that of the Department of Environment, which accepts no responsibility for the contents. If you are not the addressee, please notify the Department by return e-mail and delete the message from your system; you must not disclose or use the information contained in this email in any way. No warranty is made that this material is free from computer viruses.

Oracle LazyDBA home page