Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Resetting SQL Agent for Notifications to come through Expand / Collapse
Author
Message
Posted Monday, January 13, 2014 3:32 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 25, 2014 6:56 PM
Points: 75, Visits: 297
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?
Post #1530491
Posted Monday, January 13, 2014 3:51 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:10 PM
Points: 279, Visits: 1,112
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.
Post #1530497
Posted Monday, January 13, 2014 4:06 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 25, 2014 6:56 PM
Points: 75, Visits: 297
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?
Post #1530498
Posted Monday, January 13, 2014 4:45 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 1:10 PM
Points: 279, Visits: 1,112
AFAIK...It's Mandatory for the first time.
Post #1530502
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse