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

Enable mail profile in agent Expand / Collapse
Author
Message
Posted Tuesday, June 01, 2010 1:20 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 4:52 PM
Points: 531, Visits: 1,855
hi guys i have a question, in my sql agent i have the "Enable mail profile" box checked and my database mal is working correctly, my question is if i move to another node (failover)or restart the agent, would this make this box unchecked? i am trying to figure out what could have cause for this box to be unchecked all of a sudden in my production server, i know noone has access besides me to this server.
Post #930952
Posted Wednesday, November 24, 2010 12:19 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, October 25, 2013 1:21 PM
Points: 39, Visits: 139
The value for that check box is stored in the registry - HKLM\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent. It will probably need to be set on each node individually.
Post #1026123
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse