September 27, 2010 at 3:20 pm
All,
I have a group of 5 developers and I want them to be able to create and run jobs. I have the permissions in place that allows for each of them to create and run their own jobs. This is only half the battle though. I want each developer to be able to run any job created by any of the other 4 developers. So a job created by developer A should be able to be run by developers B, C, D, and E. Is this possible from within SQL Server? I am beginning to think not.
I cannot add them to the SQLAgentOperatorRole as that would allow them to run any job on the instance.
Thoughts? Anything anyone else has tried?
September 27, 2010 at 3:25 pm
I did come across http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/b9c76930-8f6d-4950-a6bc-22b638e4e16f/ but as Rob mentions, the solution is less than elegant. This is a test/dev box so it would not be a HUGE pain, but I am hoping for something that will not require I modify all other jobs on the instance.
September 28, 2010 at 12:50 am
You could write a stored procedure that executes the job (using sp_start_job), but you have to specify the execution user (using the EXECUTE AS clause).
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply