Toad World® Forums

Schedule Email with Query Output Attached

Hi All,

I'm looking for some tool inside Toad or in a separate solution..which can let me schedule sending query results to a list of emails.
Any ideas?

Thanks for your help!

Any edition of Toad for Oracle (or any other flavor of Toad, for that matter) can do this via the Automation Script Engine. Choose Utilities-> Automation Designer from the main menu bar. Below is a snap of an automation script that executes two of my SQL scripts, zips the results, and attached the zip file to an e-mail that gets sent to my colleagues. You can schedule via your Windows Task Scheduler.

1 Like

Thanks Gary!
Never used this feature, i will now explore all possibilities :+1: