| How to execute procedure everyday [message #364337] |
Mon, 08 December 2008 00:52  |
 |
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
