Modify SQL agent jobs without sysadmin
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?
Thanks.
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?
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We can create/modify our own jobs. But the problem is this:
We are 3 people in a team. Each one of us should be able to modify all jobs (not just our own) on dev server. So we create the jobs under sysadmin and we use sysadmin login to modify or change schedule on those jobs. THE DBA wants us to find another way where we should be able to modify jobs or change schedule on all jobs without using sysadmin. There is no one else other then us three who uses this database server.
The DBA mentioned that there may be a third party tool that works like SQL agent that may allow us to do this, but was not clear on what third party tool.
Thanks.
We are 3 people in a team. Each one of us should be able to modify all jobs (not just our own) on dev server. So we create the jobs under sysadmin and we use sysadmin login to modify or change schedule on those jobs. THE DBA wants us to find another way where we should be able to modify jobs or change schedule on all jobs without using sysadmin. There is no one else other then us three who uses this database server.
The DBA mentioned that there may be a third party tool that works like SQL agent that may allow us to do this, but was not clear on what third party tool.
Thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We can view all jobs and also right click execute job.
The problem occurs when we want to modify the jobs or change schedule on those jobs that are not created under our own authentication.
The DBA will not give us any user that has sysadmin authority.
The problem occurs when we want to modify the jobs or change schedule on those jobs that are not created under our own authentication.
The DBA will not give us any user that has sysadmin authority.
ASKER
Is there a third party tool that gives us this facility of creating/modifying/schedul
I'm not aware of such a tool. Then again, you don't really such a tool. It would likely do under the covers what I described above, that your own DBA could do. Although it might put a "cute" GUI over the final result so you don't have to directly call a stored proc.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We had another DBA look at our problem, he created a new sql user account, not sure with what permissions, but it allows us to modify, re-schedule jobs.
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?
<<
Not directly, unless you own the job. None of the Agent roles will give you that authority on existing job(s) that you do not own.