SQL 2008 SQL Server Agents Jobs, how to populate email for Notifications

Question

I am trying to add my email address to notifications for SQL Server Agent Job when it fails..

So I go SQL Server agent, open up the jobs, right click on the job and select properties and then notifications. I can check email there and have to select email address from a dropdown but the dropdown is blank and can't edit it..

Any Ideas

Answer 1

You need to first create an operator for the SQL Agent to use. Under the SQL Server Agent folder, right click on the Operators folder and select "New Operator..." Supply a name for the operator and an email address. You'll then select this operator by the name you chose in the Notifications drop down for the job.