Home » RDBMS Server » Server Administration » Regarding DBMS_JOBS
Regarding DBMS_JOBS [message #60978] Wed, 17 March 2004 17:14 Go to next message
Hiren Patel
Messages: 10
Registered: May 2002
Junior Member
-   -
- Hi Friends

I have create a procedure which executes everymorning at 5'oclcok,b by Dbms_job package,but what if i shutdown oracle at night and start oracle database after 7.00 am what will happen ? Does that procedure will execute or not ? Should i make oracle available 24 hours ? Reply Soon it's urgent]]
-

Report message to a moderator

Re: Regarding DBMS_JOBS [message #60980 is a reply to message #60978] Wed, 17 March 2004 21:15 Go to previous messageGo to next message
Deepa
Messages: 269
Registered: November 2000
Senior Member
The Server will not execute the skipped job once it is up.

It will execute the procedure the next scheduled time ie next day 5'0clock only.

Ur server has to be up for the job to be run at the specified time.

Report message to a moderator

Re: Regarding DBMS_JOBS [message #62796 is a reply to message #60978] Sun, 15 August 2004 16:35 Go to previous message
Somireddy T.N.V.V
Messages: 1
Registered: August 2004
Junior Member
Hai Deepa,

You need to make database 24*7 up. Then only automated jobs will be executed.

Report message to a moderator

Previous Topic: Oracle exp command for a remote database
Next Topic: Trouble with ORA-02074: cannot Rollback.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 24 14:09:13 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.