Change Ownership of a Maintenance Plan

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

a-848662 SSC-Addicted Points: 462 More actions · Answer 1

For any SQL 2005 guys who stumble upon this one: IN 2005 it's msdb.dbo.sysdtspackages90.

Don Norman Valued Member Points: 73 More actions · Answer 2

-- For 2005, here is a simple script:

use msdb;

go

updatedbo.sysdtspackages90

setownersid = (

select sid from msdb.sys.syslogins where name = 'LoginNameHere')

where [name] = 'MaintenancePlanNameHere';

--------------------------------------

-- and for 2000,

use msdb;

go

update sysdbmaintplans

set owner = 'LoginNameHere'

where plan_name = 'MaintenancePlanNameHere';