Resetting SQL Agent for Notifications to come through

  • 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?

  • 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.

  • 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?

  • 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