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

SQL Agent Operator Expand / Collapse
Author
Message
Posted Friday, August 23, 2013 10:11 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 1:31 PM
Points: 51, Visits: 363
I was wondering if anyone else has seen this issue. A couple of weeks ago, I renamed my SQL Agent Operator account on many machines (SQL 2005, 2008, 2008R2 and 2012 machines) and from that point on, the SQL Agent stopped sending out notifications from JOBS, maintenance plan reports, etc.

FYI, I did the rename via right click rename, not T-SQL.

I deleted that Operator, created new one (same name) and re associated all Jobs and maintenance plans and all is working fine now.

Weird huh?


SQL_Padre
aka Robert M Bishop

"Do or do not, there is no try" -- Yoda
Post #1487914
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse