Home » SQL & PL/SQL » SQL & PL/SQL » Scheduling a stored procedure/package (Oracle 10g and windows 2003)
Scheduling a stored procedure/package [message #446618] Tue, 09 March 2010 11:07 Go to next message
aijaz786
Messages: 91
Registered: February 2010
Member
Hi,

I need to schedule a stored procedure and a stored package every day @6:30 AM.

I have also a merge statement that I need to execute before stored procedure is executed.

Any support.

Thanks
Re: Scheduling a stored procedure/package [message #446621 is a reply to message #446618] Tue, 09 March 2010 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put the merge inside a procedure that also call your current procedure and the whole in a dbms_job.

Regards
Michel
Re: Scheduling a stored procedure/package [message #446622 is a reply to message #446618] Tue, 09 March 2010 11:16 Go to previous messageGo to next message
aijaz786
Messages: 91
Registered: February 2010
Member
Thanks. Please specify how to use dbms_job or dbms_schedule to schedule a procedure i.e. proc1 @6:30 AM every day.

Thanks
Re: Scheduling a stored procedure/package [message #446623 is a reply to message #446622] Tue, 09 March 2010 11:18 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the following wiki page: DBMS_JOB
6:30AM is 6/24+30/1440

Regards
Michel

[Updated on: Tue, 09 March 2010 11:20]

Report message to a moderator

Previous Topic: Any body help us.............?
Next Topic: Any parser for SQL to read and write in java
Goto Forum:
  


Current Time: Tue Dec 06 14:35:44 CST 2016

Total time taken to generate the page: 0.14841 seconds