Execute the Database Mail Stored procedures in scheduler

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 1

Pinal Dave has an article that describes how to do this:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Vidhya Sagar SSCrazy Eights Points: 8216 More actions · Answer 2

Do you want to send mail from OS scheduler? If yes then you can use sp_send_dbmail procedure in msdb database, Check http://sql-articles.com/articles/dba/database-mail article

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 3

Another article from Microsoft:

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

sram24_mca SSCrazy Points: 2633 More actions · Answer 4

Thanks for sending the articles,now we have the stored procedures for send mail.

We wanted to schedule or creating the task for that stored procedure(send mail).Can anyone help us on it.

Thanks,

Ram.

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

I just remembered that I did this before and I believe that I used s a Execute SQL Task.

I defined the From & To as well as the body. You can define an attachment.

Sorry but I do not have the code but it was very easy once I figured out how to do this.

You can also look at sending the result to a variable and look at the MEssage Source Type and Message Source in the Send Mail Task.

Sorry that I can't recall exactly what I did but is was very straight forward.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/