|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:21 PM
Points: 496,
Visits: 1,724
|
|
| 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.
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 2:34 PM
Points: 39,
Visits: 112
|
|
| 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.
|
|
|
|