Home » Infrastructure » Unix » How to execute procedure everyday (Unix,Oracle)
How to execute procedure everyday [message #364337] Mon, 08 December 2008 00:52 Go to next message
Messages: 44
Registered: December 2008
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
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.


[Updated on: Mon, 08 December 2008 01:41]

Report message to a moderator

Previous Topic: Solaris slow disk speed
Next Topic: Unix Scripting | With Oracle db
Goto Forum:

Current Time: Tue May 28 21:29:42 CDT 2024