April 2, 2007 at 10:14 am
May 4, 2007 at 12:31 pm
Pablo -
I updated the owner through the system table, sysdtspackages90, which is not the best way to approach the problem. I'm a little dismayed that the system table holding this data has a "throwback" name with "dts" in it.
First get the name of the maintenance plan you want to change:
SELECT * FROM msdb.dbo.sysdtspackages90
Then update the table after making the appropriate changes to the SQL below:
UPDATE msdb.dbo.sysdtspackages90
set ownersid = suser_sid(N'sa')
where [name] = 'DailyMaintenance'
If someone knows of a simpler and safer way, I'd like to hear about it! Good luck with your work.
Ed
July 18, 2007 at 10:31 am
I found an easy way. When connected in Management Studio as SA simply rename the Maintenance Plan. This changes the owner to sa and rebuilds all the jobs with sa as the owner. Then you can rename it back to the old name and the name change is complete.
July 18, 2007 at 7:35 pm
That is easy, thanks! Both methods still strike me as kind of an odd approach. I'll try that the next time I have the need.
July 30, 2007 at 4:14 am
Cool, I tried this out and it works indeed! Very easy way like you say.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply