Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DMcCallie
Yak Posting Veteran
62 Posts |
 Posted - 2008-01-30 : 10:12:55
|
| I have some developers that need full access to some SQL Server Agent jobs. We use a user account called PPT that ownes the jobs and use a proxy account to run the job steps.I have created a test user and granted the SQLAgentOperator Role to the test user. When I connect as the test user I can see all jobs; however, I can only view the job steps. What else do I need to do to allow full access to the developers? Currently they have to log on as PPT and make the change or go thru me. Is this the only way or what am I missing? TIA...DeWayne |
|
|
|
|
|
Developers need to modify agent jobs...