开发者

How to schedule a mysql stored procedure in windows?

开发者 https://www.devze.com 2023-01-16 22:36 出处:网络
Need to schedule in windows 2003 server to run a MySql 开发者_StackOverflow社区Stored Procedure weekly once. I tried with batch file but it dint work for me. Any ideas? Thanks in ADV.Are you running m

Need to schedule in windows 2003 server to run a MySql 开发者_StackOverflow社区Stored Procedure weekly once. I tried with batch file but it dint work for me. Any ideas? Thanks in ADV.


Are you running mySQL version 5.1 or later? If so use a mysql event.

For example:

CREATE EVENT MY_WEEKLY_THING
ON SCHEDULE EVERY 1 WEEK STARTS '2010-09-19 23:30:00'
DO CALL MY_STORED_PROCEDURE;

Your server will need to be up and running at the time mentioned, of course.

0

精彩评论

暂无评论...
验证码 换一张
取 消