non sysadmin user able to change agent job ownership RRS feed

  • Question

  • Hi experts 

    Our some of developers need to change the agent job owner ship. But on my research I can see only user can do those who got sysadmin role privileges.   Is there any way to setup non sysadmin users in SQL Server instance to change agent job ownership .

    reason is jobs are scheduled to run using agent job service user. others cant do any changes  when jobs assign to  agent job service user. plan is to change  owner back to "developers" to alter the job. and re change  back to service user . 

    Any exert idea will be highly appreciated.Many thanks  

    • Edited by ashwan Thursday, September 26, 2019 2:22 AM
    Thursday, September 26, 2019 2:16 AM


All replies