What is the best way to allow users to have access to their own SQL Agent jobs? (2008)
I know of the msdb roles, but each user needs access only to those jobs in which he is the owner. Is there a simple way to do this? Even if it's just to allow them to run it?
asked Oct 20, 2010 at 02:09 PM in Default
In the dim & distant past, when I've wanted to allow certain people access to just a couple of scheduled tasks, I've provided them with a web interface written in ASP that allows them to see the status of just those jobs to which I'm allowing them access...
I have no idea if I've still got that code.
answered Oct 20, 2010 at 03:03 PM
Wouldn't giving them the msdb role SQLAgentReaerRole suffice here? They could see all jobs, but can only start the jobs they actually own? Or is the requirement that they only see their jobs and no other?
answered Oct 21, 2010 at 12:04 AM