I have written a query I want to run against a MySQL db every hour and then email the results to a fixed email address. I know how to do this using DTS on SQL server but have no clue how to do it on MySQL. Does MySQL have an equivalent to DTS.
+1
A:
You could just write this using your favorite scripting language and then set it up as a cron job.
Taylor Leese
2010-01-07 02:06:11
What if they are not running on Unix?
Jason Short
2010-01-07 02:06:55
I assumed it was Linux based because it was MySQL. He didn't specify in the question.
Taylor Leese
2010-01-07 02:08:22
Here is a SO question about cron equivalents in Windows. That should work if it's Windows. http://stackoverflow.com/questions/132971/what-is-the-windows-version-of-cron
Taylor Leese
2010-01-07 02:11:27
A:
What I ended up doing is downloading the MySQL connector for SQL Server and then used CDO in VB Script to send the email.
Paul
2010-01-12 05:51:00