Difference between revisions of "Send email using stored procedure in mssql"

From DevOps Notebook
(Created page with "<syntaxhighlight lang="mysql> EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Db email', @recipients = '[email protected]', @body_format ='HTML', @body...")
 
(No difference)

Latest revision as of 10:23, 9 April 2020

EXEC msdb.dbo.sp_send_dbmail   
    @profile_name = 'Db email',   
    @recipients = '[email protected]',   
	@body_format ='HTML',
    @body = @body,
    @subject = @res1; 

GO