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 |
|
swoodring
Starting Member
5 Posts |
 Posted - 2002-07-16 : 16:19:56
|
| I was wondering what authority I have to give a user in order for them to be able to monitor sql jobs. I've given them access to targetserversrole which allows them to see all the jobs. But if they hit F5 refresh it does not refresh the job. It still says not running even though it is running. I signed on as SA at the same time and that profie showed the job as running when I did a F5- Refresh. What authority do I need to give them. I really don't want to give them system admin privledges. Stacy |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-07-16 : 16:47:33
|
| Not sure if this is the best way or not, but I give job administrators db_owner access to msdb. They are then able to manage all aspects of job management for jobs they own.Jeff BanschbachConsultant, MCDBA |
 |
|
|
¢ödêmån
Starting Member
32 Posts |
Posted - 2002-07-16 : 23:35:57
|
| Not sure whether giving a user 'dbo' to 'msdb' is enough.I thought you actually had to be part of a 'sysadmin' because it actually does a check.--¢ödêmån-- |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-07-17 : 12:29:50
|
| db_owner on msdb is how I have it setup right now and everything seems to be working just fine.Jeff BanschbachConsultant, MCDBA |
|
|
|
¢ödêmån
Starting Member
32 Posts |
Posted - 2002-07-18 : 04:33:44
|
| Jeff,run the following query :select [name], loginname, hasaccess, sysadmin from master..syslogins where hasaccess = 1 and sysadmin = 1and see if you are part of the sysadmin role ?--¢ödêmån-- |
|
|
|
|
|
|
monitoring jobs