The Job whose owner kept coming back...... - Andrew Calvett

The Job whose owner kept coming back......

Published Sunday, December 30, 2007 7:25 PM

This blog has been migrated to blog.calvett.co.uk. Please update your feeds.
This post can be found
here.

Comments

# Brian said on Thursday, January 31, 2008 9:42 PM

Thanks for the solution, handy stuff.  To think the owner of a maintenance plan can't be changed without this skulduggery, truly Microsoft-like.

# Eric said on Tuesday, February 5, 2008 4:09 PM

Nice!  I had not thought of looking in syspackages90 for this info.  Thanks!

# Larry Baldridge said on Friday, March 21, 2008 1:56 PM

This was spot on! My problem came because we use offshore consulting for management and we switched vendors, thus disabling old Windows Accounts. God, what a mess when you support 90 SQL Server 2005 boxes.

Thanks!

# Change maintenance plan owner | keyongtech said on Thursday, January 22, 2009 4:51 AM

Pingback from  Change maintenance plan owner | keyongtech

# The Rambling DBA: Jonathan Kehayias said on Monday, May 4, 2009 6:59 PM

I never knew this until I read a forums post today, but Maintenance Plans have owners in SQL Server. 

# Twitter Trackbacks for The Job whose owner kept coming back...... - Andrew Calvett [sqlblogcasts.com] on Topsy.com said on Sunday, April 11, 2010 6:10 AM

Pingback from  Twitter Trackbacks for                 The Job whose owner kept coming back...... - Andrew Calvett         [sqlblogcasts.com]        on Topsy.com

# Unable to determine if the owner of job has server access | SQL Server DBA Diaries of Pradeep Adiga said on Thursday, February 24, 2011 6:35 PM

Pingback from  Unable to determine if the owner of job has server access | SQL Server DBA Diaries of Pradeep Adiga

# The Return of the Living Dead:Job Owners who Keep Coming Back « - Microsoft technologies and what I do for fun - said on Saturday, July 9, 2011 5:42 PM

Pingback from  The Return of the Living Dead:Job Owners who Keep Coming Back « - Microsoft technologies and what I do for fun -