March 29, 2010 at 4:52 pm
Hello,
I have a maintenance plan that keeps crashing.
The reason is that an employee is being shown as the owner. This employee is on an extended leave. They should not have access and they do not.
However, when we go into the maintenance plan and saved something, SQL Server changes the owner of the job which is associated with the maintenance plan. SQL Server will change the ownership of the job to this same employee again!
We have reproduced this error a few times. I will change it to the right owner. If the maintenance plan is changed and saved, the job reverts back to this employee (who now has insufficient privileges).
Has anyone seen this type of behavior? If so, how do you keep the job from switching to this employee as the owner instead of the service account that I keep switching it to?
Thanks,
Tony
Things will work out. Get back up, change some parameters and recode.
March 30, 2010 at 8:06 am
I found the problem.
We had to manually change the sid. Here is an example:
use msdb
Update msdb.dbo.sysssispackages
Set [ownersid] =suser_sid('domain\owner')
Where name='- Incremental hourly backups'
This stopped the owner from changing.
Things will work out. Get back up, change some parameters and recode.
March 30, 2010 at 4:05 pm
Thanks for posting back.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 16, 2011 at 11:18 pm
This problem has been driving me nuts for a month! I finally recognized what it was doing, thanks for posting the fix, hopefully I can take care of it in a couple of days.
It would be nice if MS would fix this....
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply