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.

exec 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 #alert_message
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


No comments yet... Be the first to leave a reply!