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 2005 maintenance plan owner change Expand / Collapse
Author
Message
Posted Tuesday, May 12, 2009 8:02 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 12, 2009 9:36 AM
Points: 1, Visits: 1
how can i change maintenance plan owner in SQL2005
Post #715089
Posted Tuesday, May 12, 2009 8:14 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Friday, December 12, 2014 12:03 PM
Points: 4,363, Visits: 9,547
The easiest way is to log into SQL Server with the desired account and change the name of the maintenance plan, and then change it back. Open each sub-plan and re-save to update the jobs with the new owner.

You may need to also make a change on at least one task to force an update of the job, but I have found that most of the time that is not needed.

Another option is to update the table directly, but that is a bit more difficult.


Jeffrey Williams
Problems are opportunites brilliantly disguised as insurmountable obstacles.

How to post questions to get better answers faster
Managing Transaction Logs
Post #715112
Posted Tuesday, May 12, 2009 10:57 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 9:04 AM
Points: 414, Visits: 2,910
Check out this blog post, shows how to do it:

http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/05/04/dyk-maintenance-plans-have-owners.aspx

Andrew



Post #715299
Posted Friday, December 3, 2010 1:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, July 1, 2014 10:33 PM
Points: 5, Visits: 15
More info on this:

http://connect.microsoft.com/SQLServer/feedback/details/295846/job-owner-reverts-to-previous-owner-when-scheduled-maintenance-plan-is-edited
Post #1029693
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse