OraFAQ Forum: SQL & PL/SQL » Schedule to execute SP's...ist possible?

Home » SQL & PL/SQL » SQL & PL/SQL » Schedule to execute SP's...ist possible? (Oracle 9i ... windows xp, Unix)

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

Schedule to execute SP's...ist possible? [message #299555]

Tue, 12 February 2008 07:31

fortunethiyagu
Messages: 94
Registered: December 2006

Member

thiyagarajanpalanisamy

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

Report message to a moderator

Re: Schedule to execute SP's...ist possible? [message #299558 is a reply to message #299555]

Tue, 12 February 2008 07:38

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

DBMS_JOB

Regards
Michel

Report message to a moderator

Re: Schedule to execute SP's...ist possible? [message #299560 is a reply to message #299558]

Tue, 12 February 2008 07:41

fortunethiyagu
Messages: 94
Registered: December 2006

Member

thiyagarajanpalanisamy

Thanks michel ...

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

Confused

Fortune thiyagu

Report message to a moderator

Re: Schedule to execute SP's...ist possible? [message #299565 is a reply to message #299560]

Tue, 12 February 2008 07:49

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

DBMS_SCHEDULER is much more complex to use.
Use DBMS_JOB for this simple task.

Regards
Michel

Report message to a moderator

Re: Schedule to execute SP's...ist possible? [message #299599 is a reply to message #299555]

Tue, 12 February 2008 11:07

flyboy
Messages: 1903
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.

Report message to a moderator

Re: Schedule to execute SP's...ist possible? [message #299664 is a reply to message #299599]

Tue, 12 February 2008 22:15

fortunethiyagu
Messages: 94
Registered: December 2006

Member

thiyagarajanpalanisamy

ok yaar...

Thank you very much ...

Report message to a moderator

Previous Topic:	Mutating Table Help
Next Topic:	ORA-00907: missing right parenthesis

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jul 20 14:31:12 CDT 2025