Home » SQL & PL/SQL » SQL & PL/SQL » Running a procedure every 10 minutes
Running a procedure every 10 minutes [message #1401] Fri, 26 April 2002 06:11 Go to next message
Dave
Messages: 92
Registered: August 1999
Member
I have created a procedure that looks at values in a table and does certain things when certain thresholds are hit. Currently, I have a perl script that is run by cron every 10 minutes that connects to the dB and runs the stored procedure. I want to automate this without having to use Perl. I am wondering if this is possible? Just have a stored procedure be called automatically every 10 minutes.
Thanks

Report message to a moderator

Re: Running a procedure every 10 minutes [message #1402 is a reply to message #1401] Fri, 26 April 2002 06:28 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
yeah.
within oracle you can schedule it (its not a widely recomended method).
use DBMS_JOB package.
look in documentation for more info.
else
use simple unix shell scripts to do the same.

Report message to a moderator

Re: Running a procedure every 10 minutes [message #1416 is a reply to message #1402] Sat, 27 April 2002 04:53 Go to previous message
Dave
Messages: 92
Registered: August 1999
Member
yeah, that's what I've been reading, that it is not really recommended at all, but was just making sure. Currently I've got a unix shell script run by cron every 5 minutes and it does the job just fine.

Thanks!

Report message to a moderator

Previous Topic: Temporary Storage
Next Topic: Identifying Rollback Segment for a transaction
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 20:38:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.