Return
-
Title
How to change plan owner in 5.0 Maintenance Plan? -
Description
How to change plan owner in 5.0 Maintenance Plan (MP)?
-
Resolution
1- Open up the Maintenance Plan designer in LiteSpeed
2- Click on the Manage Connections toolbar option - the button is to the far right
3- Edit the connection and change as neededWorkaround:
LiteSpeed Console does not have the function to change the owner of the maintenance plan. The only way to do this, is change it manually.Steps to change the owner of a maintenance plan (MP):First use the querySelect * from MSDB..Sysusersto get ownerid.2005
UPDATE
[msdb].[dbo].[sysdtspackages90]
SET
[ownersid] = <ownerid>
WHERE
[name] = <maintenance plan name>2008
UPDATE [msdb].[dbo].[sysssispackages]
SET
[ownersid] = <ownerid>
WHERE
[name] = <maintenance plan name>To change the owner a job:
UPDATE [msdb].[dbo].[sysjobs]
SET
[owner_sid] = <ownerid>
WHERE
[name] = <job name>
-
Defect ID
CR59900 -
Additional Information
For SQL 2000, we use legacy plan, which is different from the above query for Sql Server 2005. The table for the MP storing the owner information is msdb.dbo.sysdbmaintplans. For SQL 2008, the table for the MP storing the owner information is msdb.dbo.sysssispackages.