SQL Server Performance Forum – Threads Archive

SQL agent jobs

I need to grant permissions to a developer so that she will be able to view and execute all jobs owned by a sysadmin login. But, I don’t want to grant her sysadmin role. Are there any ways to do this so she can view and run the jobs not owned by her? Thanks,
Ben

---

In SQL 2000 you need to put that user in TargetServersRole in MSDB.
In SQL 2005 :
SQL Server 2005 introduces the following msdb database fixed database roles, which give administrators finer control over access to SQL Server Agent. The roles listed from least to most privileged access are: SQLAgentUserRole SQLAgentReaderRole SQLAgentOperatorRole
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.

---

Thanks and it worked.

---

]]>