Home » RDBMS Server » Server Administration » dbms_job (Oracle 9i)
dbms_job [message #295827] Wed, 23 January 2008 12:07 Go to next message
rajiv123
Messages: 4
Registered: January 2008
Junior Member
Hello, I have a question about dbms job. What happens if I have a scheduled dbms_job that runs every two hours and the database is shutdown (abort)? Once the database is up, will the job start up on its own or do I have to reschedule it? If it does not start up, then what do I need to do in the future in order for it to start up? Manually start it every time?


p.s. oracle version 9.2.0.1.0

also, is there a way to get notified if a dbms_job fails to run?



[Updated on: Wed, 23 January 2008 12:16]

Report message to a moderator

Re: dbms_job [message #295830 is a reply to message #295827] Wed, 23 January 2008 12:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If I say it will start, then do you trust me or not?
Why don't you try?

Quote:
is there a way to get notified if a dbms_job fails to run?

Notified? No but you can know it either have a look at alert.log or dba_jobs view.

Regards
Michel
Re: dbms_job [message #295831 is a reply to message #295830] Wed, 23 January 2008 12:46 Go to previous messageGo to next message
rajiv123
Messages: 4
Registered: January 2008
Junior Member
Well, that's the thing. I dont know if it is normal, but the job did not start. It shows that it's not broken, but it defenatelly did not start. So, I guess I am trying to figure out what if it is a "normal" Oracle behavior (i.e. if Oracle database is shutdown in an abnormal fashion then your dbms_job will not start by itself) or if there is something wrong with a job itself.

thank you for alert logs idea...
Re: dbms_job [message #295833 is a reply to message #295831] Wed, 23 January 2008 12:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also check your job_queue_processes parameter.

Regards
Michel
Re: dbms_job [message #295836 is a reply to message #295833] Wed, 23 January 2008 13:10 Go to previous messageGo to next message
rajiv123
Messages: 4
Registered: January 2008
Junior Member
It's actually set to zero, might that be a problem?
Re: dbms_job [message #295839 is a reply to message #295836] Wed, 23 January 2008 13:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is set to 0, no job starts as there is no process to execute it.

Regards
Michel
Re: dbms_job [message #295840 is a reply to message #295839] Wed, 23 January 2008 13:30 Go to previous message
rajiv123
Messages: 4
Registered: January 2008
Junior Member
Thank you!
Previous Topic: Can PMON be killed?
Next Topic: Patches
Goto Forum:
  


Current Time: Sun Dec 04 04:20:50 CST 2016

Total time taken to generate the page: 0.14549 seconds