Disable email notifications in SQL Server Agent

• kathy o

  Mr or Mrs. 500

  Points: 588

  More actions

  March 21, 2012 at 2:00 pm

  #266076

  I'm trying to disable the email notification that I originally set up in the Job Properties of a SQL Server Agent job. I have unchecked the 'email' box, but still receive emails. Any thoughts?

• WaIIy

  Ten Centuries

  Points: 1387

  More actions

  April 4, 2012 at 3:06 pm

  #1469191

  Look once again that the box is unchecked - And recycle the SQL Server Agent if it was indeed unchecked.

  -- Wally

  [font="Verdana"]-- Wally
  -- Reluctant DBA[/font]

• kathy o

  Mr or Mrs. 500

  Points: 588

  More actions

  April 5, 2012 at 9:36 am

  #1469641

  Thanks for your reply. I ended up re-creating the job. The box was unchecked, but I kept getting the email message. Re-creating it worked, but it wasn't a good solution. What do you mean by 'recycle' the SQL Server Agent?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  April 5, 2012 at 9:46 am

  #1469649

  kathyoshea (4/5/2012)

  ---

  Thanks for your reply. I ended up re-creating the job. The box was unchecked, but I kept getting the email message. Re-creating it worked, but it wasn't a good solution. What do you mean by 'recycle' the SQL Server Agent?

  Stop and Start SQL Server Agent.

  I think there is actually an option to RESTART if you right clink on SQL Server Agent as well.