Avatar of Yogib01
Yogib01
 asked on

SQL Server Agent Job Notifications Not Working

have SQL Server 2008 R2 have various profiles setup on database email and can send test email fine from all profiles. Have enabled mail profile on alerts for sql server agent to use database email and selected email profile. Operators have been created which have been setup to notify if scheduled backup jobs fail that are jobs under sql agent.

the problem i have is that no emails are being sent if job fails

have set notify to send if job completes successfully and still i get no emails.

what is required to get these job notifications working
Microsoft SQL Server 2005

Avatar of undefined
Last Comment
Yogib01

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
EugeneZ

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
David Todd

Hi,

I agree with EugeneZ.

I found that I needed to restart SQL agent.

This may not require an outage if there are no "business" jobs.

Regards
  David
Ilya Rubinshteyn

Right click on SQL Server Agent->Properties, click on alerts, check the box to enable mail profile and select the correct profile. Make sure you have fail safe operators set up and enabled if needed. Click OK and restart the agent
Yogib01

ASKER
this did resolve the the issue and notifications are now being sent from the SQL Agent Jobs
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes