InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 14:03:54 GMT20http://www.sqlservercentral.com/Forums/Topic859461-146-1.aspxI 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.Fri, 05 Feb 2010 05:38:45 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic859461-146-1.aspxThanks 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.Fri, 05 Feb 2010 02:55:57 GMTsram24_mcahttp://www.sqlservercentral.com/Forums/Topic859461-146-1.aspxAnother article from Microsoft:http://msdn.microsoft.com/en-us/library/ms186352.aspxThu, 04 Feb 2010 04:30:38 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic859461-146-1.aspxDo 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 articleThu, 04 Feb 2010 04:27:55 GMTvidhya sagarhttp://www.sqlservercentral.com/Forums/Topic859461-146-1.aspxPinal Dave has an article that describes how to do this:http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/Thu, 04 Feb 2010 04:27:08 GMTWelsh Corgihttp://www.sqlservercentral.com/Forums/Topic859461-146-1.aspxHi Guys, How can we execute the Database mail stored procedures in scheduler.Thanks,Ram.Thu, 04 Feb 2010 03:14:39 GMTsram24_mca