Are we talking about a job scheduled via dbms_job? Or via cron or some
other operating system scheduler?

Do you have exception handling code in your job that writes error
messages to an error table, log file, etc? If not, that's likely where
you want to start-- if your code throws an error, that won't be written
to the alert log. If you're using dbms_job, do you see entries in the
DBA_JOBS table that indicate that the job has failed?

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: HEWAVITHARANA Janaka
[mailto:oracledba-ezmlmshield-x85939754.[Email address protected]
Sent: Thursday, September 08, 2005 9:16 PM
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


Oracle LazyDBA home page