SQLTeam.com | Weblogs | Forums

Problem with SQL Server Agent Job Notifications


#1

In SQL Server 2012, I have configured Database Mail (sends test e-mail successfully to e-mail address I explicitly enter for this purpose), created a simple test job with two steps and added an operator (me, same e-mail adress as when sending test e-mail). I have configured notifications for the job to send e-mail to the operator (me) when the job completes. No e-mails get sent regardless if I run the job maually or using a schedule. Any ideas what else I need to do?


#2

I found the problem in the error logs. I did not "enable mail profile" under Alert System in SQL Server Agent Properties.