Scheduler for .sql query

[expired user #8350]'s profile image [expired user #8350] posted 10 years ago in General Permalink
Hi everyone,

I know that similar topic was hire but it was 6 years ago.
My case is looking like -> I got .sql file with query and I need to run it every Sunday @ 13:00
How to schedule it ? I was try to make cli command file but no success,
I don’t have to export result – I will copy it manually at Mondays – HS will runs on virtual machine.

Any Idea ?
Can anyone help me ?
jfalch's profile image jfalch posted 9 years ago Permalink
mysql contains an event scheduler since v5.1.6. cf this on defining events.

otherwise, get hold of a mysql.exe, use

mysql.exe -h hostname -u username --password=xxxx <stmts.sql

in a batch file. windows task manager can then be used to implement running this batch regularly.

Please login to leave a reply, or register at first.