Scheduale a stored procedure

[KrippZ]

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

[Bill Karwin]

Kr****@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.