Home Dashboard Directory Help
Search

SQL Server Job Owner reverts to user who saved the maintenance plan by dhechle


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 776776
Opened: 1/17/2013 4:17:20 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

This has been raised since SQL Server 2005 and appears it is still a bug in SQL Server 2008 R2. Other reports are 295846 and 454073.
When changing the owner of a SQL job to "sa" for example and then later save the maintenance plan that the job is part of the owner of the SQL job reverts back to the user that saved the maintenance plan, in my case my domain account.
This is not ideal in that when users leave the company the jobs fail. I have seen there are some work arounds to this but why is this not being fixed in any service packs and or upgrades?
Details
Sign in to post a comment.
Posted by Microsoft on 1/29/2013 at 4:18 PM
I can see that this issue was already fixed in SQL Server 2012, but we didn't port the fix back to SQL Server 2008R2. I will keep this issue to port the change from SQL Server 2012 to SQL Server 20008R2 SP3, so keep tuned till we release this SP.

Thank you
Alex Grach [MSFT]
Posted by Microsoft on 1/29/2013 at 2:04 PM
Thank you for reporting this issue - we are investigating and will update you when we have more information.

Thanks,

Alex Grach [MSFT SQL SERVER]
Sign in to post a workaround.