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