DTS like process for MySQL

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.

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

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