How to execute procedure everyday [message #364337] |
Mon, 08 December 2008 00:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/132854.jpg) |
deb.b
Messages: 44 Registered: December 2008
|
Member |
|
|
I want to execute a procedure (say procedure b) everyday. Can anyone tell me how to execute a procedure everyday using cron?
Do I need to write any shell script for this? What are the steps that would involved to run the procedure everyday? Do I need to
go to a specific folder?
|
|
|
Re: How to execute procedure everyday [message #364344 is a reply to message #364337] |
Mon, 08 December 2008 01:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68658 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
If you want to execute it with cron I recommend you "man cron" and/or post your question in a Unix forum. (And yes you have to create a shell script there are many in this forum.)
If this is a PL/SQL procedure, it is better (but not always allowed in entreprise) to use Oracle scheduler with dbms_job or dbms_scheduler.
Regards
Michel
[Updated on: Mon, 08 December 2008 01:41] Report message to a moderator
|
|
|