x

SQL Agent Job access

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?

Thanks!!!
more ▼

asked Oct 20, 2010 at 02:09 PM in Default

sqltracy gravatar image

sqltracy
33 3 3 5

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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.
more ▼

answered Oct 20, 2010 at 03:03 PM

ThomasRushton gravatar image

ThomasRushton ♦
34.2k 18 20 44

hmm . . . yes a GUI seems like the only way. Maybe in the next version of SQL Server we can give access at the level - Thanks for feedback! :)
Oct 20, 2010 at 03:17 PM sqltracy
(comments are locked)
10|1200 characters needed characters left
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?
more ▼

answered Oct 21, 2010 at 12:04 AM

WilliamD gravatar image

WilliamD
25.9k 17 19 41

"Or is the requirement that they only see their jobs and no other?" - that was my reading of it...
Oct 21, 2010 at 12:42 AM ThomasRushton ♦

Difficult to be sure - "each user needs access only to those jobs in which he is the owner"

Is that access in terms of controlling or also viewing?
Oct 21, 2010 at 12:52 AM WilliamD
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x91
x29
x5

asked: Oct 20, 2010 at 02:09 PM

Seen: 1187 times

Last Updated: Oct 20, 2010 at 02:09 PM