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
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
Michel Cadot
Messages: 68625
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

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


Current Time: Thu Mar 28 17:37:23 CDT 2024