Find owner of maintenance plan

To view the owner of maintenance plan execute the following select statement.

–Above 2008
select [ownersid] , SUSER_SNAME([ownersid]) from msdb.dbo.sysssispackages
where [name] like ‘<mainatenanceplanname>’

To update owner of maintenance plan execute the below command:
update msdb.dbo.sysssispackages
set [ownersid] = suser_sid(‘<loginname>’)
where [name] like ‘<mainatenanceplanname>’

–For 2005
select name,owner from dbo.sysmaintplan_plans

UPDATE msdb.dbo.sysdtspackages90
SET OWNERSID = SUSER_SID(‘<loginname>’)
WHERE [Name] like ‘<mainatenanceplanname>’

–For 2000
select plan_name,owner from dbo.sysdbmaintplans

update dbo.sysdbmaintplans set owner =’LoginName’ where owner =’LoginName’

To change job owner expand SQL Server Agent, expand Jobs, right-click the job, and then click Properties.In the Owner list, select a login.
You must be a system administrator to change the owner of a job.