Home Forums SQL Server 2008 Security (SS2K8) Non-sysadmin needs ability to maintain SQL Agent Jobs RE: Non-sysadmin needs ability to maintain SQL Agent Jobs
priesol
Newbie
Points: 9
More actions
January 3, 2014 at 2:52 am
#1677162
It can by done by overriding of sp_update_job procedure. Steps described here: http://borishristov.com/blog/modifying-not-owned-sql-agent-jobs-without-being-a-sysadmin/[/url]