Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can only sysadmin check job history? 1

Status
Not open for further replies.
pandatime

pandatime

Programmer
Jan 29, 2010
92
AU
Hi,

is there a way to let someone check job history but not as sysadmin?

Thanks
 
Sort by date Sort by votes
You can add them to the SQLAgentReaderRole database role in the MSDB database.


HTH, Dan
 
Upvote 0 Downvote
I figured there might be a role, didn't realize it was at db level...

Thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

briangriffin
  • Locked
  • Question
Runaway Job
Replies
1
Views
201
fredericofonseca
fredericofonseca
RRinTetons
  • Locked
  • Question
Tool for job scheduling
Replies
0
Views
169
RRinTetons
RRinTetons
RRinTetons
  • Locked
  • Question
Sleuthing out job failure
Replies
3
Views
206
johnherman
johnherman
lavadan
  • Locked
  • Question
SQL Maintenance Job Schedule
Replies
0
Views
75
lavadan
lavadan
dgillz
  • Locked
  • Question
How to create login that has access to only certain tables in a database
Replies
4
Views
91
SQLBill
SQLBill

Part and Inventory Search

Sponsor

Back
Top