DTS like process for MySQL

Question

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.

Sorry I forgot to mention it is running on Windows 2003 server — Paul, Jan 07 '10 at 03:27

score 2 · Answer 1 · answered Jan 07 '10 at 02:06

2

You could just write this using your favorite scripting language and then set it up as a cron job.

answered Jan 07 '10 at 02:06

Taylor Leese

51,004
28
112
141

What if they are not running on Unix? – Jason Short Jan 07 '10 at 02:06
1

I assumed it was Linux based because it was MySQL. He didn't specify in the question. – Taylor Leese Jan 07 '10 at 02:08
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 Jan 07 '10 at 02:11

score 0 · Accepted Answer · answered Jan 12 '10 at 05:51

0

What I ended up doing is downloading the MySQL connector for SQL Server and then used CDO in VB Script to send the email.

answered Jan 12 '10 at 05:51

Paul

757
3
10
38

DTS like process for MySQL

2 Answers2