msdb..sp_update_job does not work with Windows (Active Directory) groups as the @owner_login_name - by DIMiller

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.

Sign in
to vote
ID 776349 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 1/11/2013 10:03:57 AM
Access Restriction Public


I need to be able to change the owner of a particular job to an Active Directory Security Group.  It appears the accepted method for doing this is to use the msdb stored procedure sp_update_job.  When using a Windows Login as the @owner_login_name parameter, sp_update_job works as expected.  However, if you attempt to use an Active Directory Security group (for which a login has been created), you get the following error message:

Msg 14234, Level 16, State 1, Procedure sp_verify_job, Line 197
The specified '@owner_login_name' is invalid (valid values are returned by sp_helplogins [excluding Windows NT groups]).
Sign in to post a comment.
Posted by Doylen on 12/5/2016 at 2:29 PM
Bug still present in SQL Server 2016.
Was able to use the workaround noted in this article to change the owner of a SQL Job to an AD Group.
Posted by Microsoft on 1/15/2013 at 10:25 AM

Thank you for reporting this issue. We will take a look on it and let you know what is the outcome.
Again, thank you very much for finding time to report this issue.

Evgeny Krivosheev,
SQL Server Program Manager