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

sql-server sql-server-agent
StevieB picture StevieB · Apr 18, 2011 · Viewed 27.3k times · Source

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

Joe Stefanelli picture Joe Stefanelli · Apr 18, 2011

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.

enter image description here

Related questions

Cannot bulk load because the file could not be opened. Operating System Error Code 3

I'm trying to set up a Stored Procedure as a SQL Server Agent Job and it's giving me the following error, Cannot bulk load because the file "P:\file.csv" could not be opened. Operating system error code 3(failed to …

Read More
How do I execute a stored procedure in a SQL Agent job?

I am using SQL Server 2008 and I need to run a SQL Job from SQL Server Agent. I am new to SQL Server Job and I want to execute a stored procedure regularly from a SQL Server Job. But I …

Read More
Could not obtain information about Windows NT group user

I am creating a SQL Server Replication using a script. When I try to execute The job failed. Unable to determine if the owner (STAR\moorer7) of job L3BPT2M-Atlas-14 has server access (reason: Could not obtain information about …

Read More