Modify SQL agent jobs without sysadmin
Posted on 2013-12-10
We are using SQL server 2012 Standard Edition.
We have our development server where we do our research and development, before any process is deployed to production. These servers are managed by the DBA team. The DBA team does not want us to give sysadmin rights on the dev server. Right now the way the permissions are set up, we cannot modify or change schedule on any job without sysadmin rights. The DBA has mentioned that if we can suggest any way where we can do this without using sysadmin, they will let us do it.
Is there any way to be able to modify SQL agent jobs without having sysadmin rights?
Is there any way to be able to modify schedule on SQL agent jobs without having sysadmin rights?