Hi!
Im writing a asp.net 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.
Cheers
//KrippZ
KrippZ@gmail.com wrote:
> Hi!
>
> Im writing a asp.net 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.
Yes, using the EVENT feature of MySQL 5.1.
http://dev.mysql.com/doc/refman/5.1/en/events.html
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.
Regards,
Bill K.