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 |
|
Skorch
Constraint Violating Yak Guru
300 Posts |
 Posted - 2009-01-28 : 19:24:11
|
| Is there a way to view and manage Jobs in SQL Server 2000 without being a part of the sysadmin role? DBO access to msdb doesn't seem to do it so I'm wondering if someone knows another way. I did find this article online:http://blogs.techrepublic.com.com/datacenter/?p=428However I'm wondering if you guys know a way around it. Thanks!Some days you're the dog, and some days you're the fire hydrant |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-28 : 19:40:44
|
| Put the user in TargetServersrole in MSDB. |
 |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
Posted - 2009-01-29 : 17:57:23
|
| You are awesome. Thank you so much!<hr/>Some days you're the dog, and some days you're the fire hydrant. |
|
|
|
|
|
|
View Jobs without sysadmin