Send email using stored procedure in mssql

From DevOps Notebook
Revision as of 10:23, 9 April 2020 by MilosZ (talk | contribs) (Created page with "<syntaxhighlight lang="mysql> EXEC msdb.dbo.sp_send_dbmail @profile_name = 'Db email', @recipients = '[email protected]', @body_format ='HTML', @body...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
EXEC msdb.dbo.sp_send_dbmail   
    @profile_name = 'Db email',   
    @recipients = '[email protected]',   
	@body_format ='HTML',
    @body = @body,
    @subject = @res1; 

GO