October 2, 2003 at 9:05 am
I have staff members who need monitor vendor supplied SQL Server jobs. How can I let them see the jobs without having to grant SysAdm?
October 2, 2003 at 9:20 am
If you are running below service pack 3, you can add those users into TargetServerRole role in MSDB.
Service pack 3 makes changes on the permissions to deny TargetServerRole on stored procedures that are used adminstrater jobs. You may have to change the permissions on TargetServerRole to these SPs.
October 2, 2003 at 4:35 pm
Or build a job that loads the results of jobs into some table and let them query that table.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
October 2, 2003 at 10:24 pm
What about creating another role with select only on thE relevent msdb tables?
Edited by - growl on 10/02/2003 10:24:44 PM
October 3, 2003 at 1:40 am
In our environment, which is now entirely SQL 2K SP3, we were still able to use the TargetServerRole, with very few tweaks to it's permissions. Our objective was only to allow them to view information about the jobs via Enterprise Manager. We didn't want any of them to be able to modify the jobs in any way...this has worked out well for us so far. (That is, of course, until the next major Service Pack or version change.) If this is your goal, the role may work for you.
Joshua Jones
Director, Global Database Services
PGi
October 3, 2003 at 2:49 pm
I checked BOL, no info. Where do I find more about TargetServerRole?
October 3, 2003 at 3:06 pm
That's becuase it's primarily used by SQL Server itself, in the administration of MSX/TSX jobs. I don't recall any specific links that'll help describe it better; I spent a lot of time playing with it on a test box to get it just right. Maybe someone else on the board has some good documentation/links?
Joshua Jones
Director, Global Database Services
PGi
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply