Post reply

Resetting SQL Agent for Notifications to come through

  • January 13, 2014 at 3:32 pm

    #287214

    Hey guys,

    I am setting up SQL Agent Operator to be used for Job notification when the job fails. The only problem I've encountered was that when the Operator was setup, I could not get the email notifications to come through. Eventually, I resolved it by restarting the SQL Agent Service. The problem is that I can't really do something like this in the production, because of continually running jobs, and scheduling maintenance is going to be pretty difficult. Is there some other way I can resolve this issue, aside from restarting the SQL Agent Service?

  • January 13, 2014 at 3:51 pm

    #1679750

    You don't need to restart Agent Service each and every time you create a new Operator to work.

    However I do remember on SQL 2005 and 2008, Agent Service needs to be restarted once(Just for the first time), after you enable Alert System (Enable Mail Profile) for your SQL Server.

    Again...it's just one time operation, something which you would do right after enabling Mail Profile for your SQL Agent.

  • January 13, 2014 at 4:06 pm

    #1679751

    You are absolutely right, I forgot to mention that I had to enable Mail Notification in SQL Agent Alert properties. Any way of getting around restarting Agent, or is that mandatory?

  • January 13, 2014 at 4:45 pm

    #1679754

    AFAIK...It's Mandatory for the first time.

Viewing 4 posts - 1 through 3 (of 3 total)

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