Post reply

Job Notifications to previously working Operator are now Failing

  • May 8, 2009 at 2:53 pm

    #132137

    Hoping for some insight on this one because I'm not having any luck with the SQL Logs.

    I have 2 Jobs (each with 2 steps) that are very basic (each step calls an SP) that I've been sucesfully running nightly for several months and that I have always gotten email notifications on with no problems till last night which was the first time I did not get a notification.

    I have verfiied that the email address listed for the oprator is valid. I have checked the Jobs log entries and aside from the standard message that the Job succeeded there is nothing other then the following:

    NOTE: Failed to notify 'John.Smith' via emai

    Now I did make some changes yesterday to DB Mail on this SQL Server but I have re-tested those profiles and emails are getting sent so I'm not sure if changes to DB Mail have any relevance to the jobs failure to send the email notification. The operator does not appear to be directly linked to DB Mail as far as I can tell.

    Any thoughts?

    Thanks

    Kindest Regards,

    Just say No to Facebook!

  • May 8, 2009 at 4:53 pm

    #991520

    Agent mail is (slightly) different that DB mail.

    Check what's up on SQL Server Agent | Properties | Alert system

  • May 8, 2009 at 5:54 pm

    #991535

    Pam Brisjar (5/8/2009)

    Agent mail is (slightly) different that DB mail.

    Check what's up on SQL Server Agent | Properties | Alert system

    It's set to use DB Mail and the account selected is the one that I set a while back. I'm wondeirng if changing something in one area (such as Opertaors ) that deals with email ins ome way has an effect on other areas. I also changed out some Operators but I used SQL Servers Transfer To feature to move everything from the old operator to the new.

    Thoughts?

    Thanks

    Kindest Regards,

    Just say No to Facebook!

  • May 8, 2009 at 7:33 pm

    #991542

    I'd try stopping and restarting Agent. Also look at the jobs themselves to see if anything has monkeyed with their settings.

  • May 18, 2009 at 10:08 am

    #996460

    Just wanted to thank all posters for responding and to let all know I have fixed this. It was an issue of putting one part of the brain into gear before releasing the whol thing from Park first; aka a goof on my part. I have several SQL Boxes to manage and I mixed up 2 whith almost identical names (1 character difference).

    Thanks again

    Kindest Regards,

    Just say No to Facebook!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply