Send email using stored procedure in mssql
From DevOps Notebook
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Db email',
@recipients = '[email protected]',
@body_format ='HTML',
@body = @body,
@subject = @res1;
GO
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Db email',
@recipients = '[email protected]',
@body_format ='HTML',
@body = @body,
@subject = @res1;
GO