469,623 Members | 1,053 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

Scheduale a stored procedure

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

Jul 24 '06 #1
1 2984
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.
Jul 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Rhino | last post: by
8 posts views Thread by Thomasb | last post: by
2 posts views Thread by Dino L. | last post: by
2 posts views Thread by jed | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.