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]).