SQL Mail/Database Mail

ubeauty · February 10, 2011, 4:12am

Is there any tools in Toad for SQL Server such as SQL Mail/Database Mail found in Managment Studio.
I’d like to use such a tool to maybe fire off certain reports at specified times based on a query or specific triggers.

Thanks in advance

Karl

Valentine · February 11, 2011, 2:01am

Hi ubeauty,

Can you please share with me your workflow so I can answer your question.
Note: there are basic facility in Toad to manage SQL Mail/Database Mail, however I’m not sure if they are enough to accomplish your goals.

ubeauty · February 11, 2011, 2:43pm

Hi Valentine, nothing planned as yet.
Can you let me know where you access the SQL Mail/Database Mail facility within Toad so i can take a look.

Many thanks

Karl

Valentine · February 13, 2011, 12:18am

Ubeauty,

Please take a look at management folder in object explorer and you will see SQL Mail and DB Mail (see attached image)

ubeauty · February 15, 2011, 5:58am

Many thanks Valentine