Home » SQL & PL/SQL » SQL & PL/SQL » Schedule to execute SP's...ist possible? (Oracle 9i ... windows xp, Unix)
Schedule to execute SP's...ist possible? [message #299555] Tue, 12 February 2008 07:31 Go to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Hi everyone...

I am having 10 procedures and now i want to schedule it to run automatically... say like today night by 10pm i have to execute all the stored procedures.

Is it possbile in oracle? If possible how could we do?

Please provide me some help materials or sample code...

Thank you everyone...

Fortunethiyagu
Re: Schedule to execute SP's...ist possible? [message #299558 is a reply to message #299555] Tue, 12 February 2008 07:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBMS_JOB

Regards
Michel
Re: Schedule to execute SP's...ist possible? [message #299560 is a reply to message #299558] Tue, 12 February 2008 07:41 Go to previous messageGo to next message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

Thanks michel ...

can we use DBMS scheduler to do such? because i was adviced to use such .. Confused

Fortune thiyagu
Re: Schedule to execute SP's...ist possible? [message #299565 is a reply to message #299560] Tue, 12 February 2008 07:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBMS_SCHEDULER is much more complex to use.
Use DBMS_JOB for this simple task.

Regards
Michel
Re: Schedule to execute SP's...ist possible? [message #299599 is a reply to message #299555] Tue, 12 February 2008 11:07 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
> can we use DBMS scheduler to do such?

You can, but only in Oracle version 10.1 and higher. It was not available in Oracle 9i.
Re: Schedule to execute SP's...ist possible? [message #299664 is a reply to message #299599] Tue, 12 February 2008 22:15 Go to previous message
fortunethiyagu
Messages: 94
Registered: December 2006
Member

ok yaar...

Thank you very much ...
Previous Topic: Mutating Table Help
Next Topic: ORA-00907: missing right parenthesis
Goto Forum:
  


Current Time: Tue Dec 06 10:14:22 CST 2016

Total time taken to generate the page: 0.16727 seconds