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

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


2
0
Sign in
to vote
ID 776776 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/17/2013 4:17:20 AM
Access Restriction Public

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?
Sign in to post a comment.
Posted by Alex [MSFT] 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 Alex [MSFT] 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]