Scheduale a stored procedure

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

Im writing a webapp and I need some help with scheduling of a
stored procedure.
I'd like to know if it's possible to have a stored produdere (that I
have written) to be schedualed for execution. I'd like it to exec on
the mysql server on predetermined hours.



Re: Scheduale a stored procedure wrote:
Quoted text here. Click to load it

Yes, using the EVENT feature of MySQL 5.1.
However, 5.1 is still in beta currently.

The other solution is to write a scheduled job with "cron" (UNIX/Linux)
or "AT" (Windows) to run a command at a specific hour.  The command you
run should be a script (shell script on UNIX/Linux, BAT script on
Windows) that executes whatever SQL statements you want.

Bill K.

Site Timeline