Hi
Can you check what is value for Oracle parameter job_queue_processes .
It should be greater than 0 to execute database job
Thanks
Saqib
-----Original Message-----
From: HEWAVITHARANA Janaka
[mailto:oracledba-ezmlmshield-x85939754.[Email address protected]
Sent: 09 September 2005 02:16
To: LazyDBA Discussion
Subject: Database Job
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.
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html
************** E-mail Disclaimer **************
This e-mail message is confidential and for use by the addressee only. If you are not the intended addressee, please reply to the sender and then delete the message from your computer.
Please note that any views or opinions presented in this e-mail are those of the author and do not necessarily represent the views or opinions of The Benenden Healthcare Society Limited.
You should check this e-mail and any attachments for the presence of viruses. The Benenden Healthcare Society Limited accepts no liability for any damages caused by any virus transmitted by this e-mail or its attachments.
The Benenden Healthcare Society Limited is an incorporated friendly society, registered under the Friendly Societies Act 1992, registered number 480F. The Society’s contractual business (the provision of tuberculosis benefit) is authorised by the FSA. The remainder of The Society’s business is undertaken on a discretionary basis. The Society is subject to FSA requirement for prudential management.
Registered Office Address: The Benenden Healthcare Society Limited,
Holgate Park Drive, York. YO26 4GG.
Tel: 0870 7545 700 Fax: 0870 7545 822
www.benenden.org.uk
Oracle LazyDBA home page