Thursday, December 24, 2015

Send Email SQL Server Multiple Users/Single User

exec msdb.dbo.sp_send_cdosysmail
@From = N'xxxxxxxx\SQL1@MHC.Com',
--@To = N'Rajeevkum@gmail.Com;xxxx.yyyy@yahoo.com',
@To = N'Rajeevkum@gmail.Com',
@ReplyTo = N'Rajeevkum@gmail.Com',
@Subject = N'Auto: Success Rx Data Load ',
@Body = 'You are Successfully loaded Data in Rx Invoice Table. <BR> Please Run R5509654 in JDE to finish the Upload process.',
@BodyType ='HTMLBODY'

No comments: