SQL Server Email Alerts Notifications
Then send the email to the desired recipients. In order to do this we need to create a Database Mail Profile. More details on How to create a Database Mail Profile can be found in the Books Online.
msdb..sp_send_dbmail @profile_name = ‘Profile Name’
,@recipients =’Email Address’
,@subject = @mail_subject
,@body = @mail_body
,@body_format = ‘HTML’
,@importance = ‘High’
set @j = @j+1
drop table #replicationalerts
drop table #subscriber_alert_message
That’s it, now you will have a much more user friendly email alerts notification system.
Download the full listing of Step 2 here
Pages: 1 2