OraFAQ Forum: Server Administration » dbms

Home » RDBMS Server » Server Administration » dbms_job (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_job [message #295827]

Wed, 23 January 2008 12:07

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

Michel Cadot
Messages: 68684
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

Report message to a moderator

Re: dbms_job [message #295831 is a reply to message #295830]

Wed, 23 January 2008 12:46

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...

Report message to a moderator