This is, specifically, a followup to
http://weblogs.sqlteam.com/chrism/archive/2008/11/25/Hyperbac-anyone.aspx
Been using the software for 2 months, and it works very well. I have one issue on one server (a development box) that their support team is aware of and has been very helpful with tracking down. Otherwise, it works, it works well, and I can throw a simple little executable at my ISV's when they need database backups to diagnose problems.
It works well, it's simple, and it's reliable. It hasn't failed, and hasn't glitched (OK, except for the dev box, but *everything* glitches on dev boxes).
I still have a SQL Server 2000 server.
Don't blame me, blame my ISV. The upgrade to their software to support SQL Server 2005 is coming out in August. Of 2006.
Anyway. I still have to support this thing. And it's a fairly large database, with some sensitive information in it. And we have on call developers who need to support some of the jobs running. They needed access to be able to view jobs and job history. So I went in and added them to the SQLAgentOperator role...oh uh...wait. There isn't one in SQL Server 2000. So I gave the developers DBO to MSDB. Didn't work.
So I did a google search, and came across this:
http://www.sql-server-performance.com/faq/sqlagent_scheduled_jobs_p1.aspx
You have to add them to the TargetServers role.
Let me repeat that. I have to put my developers into hte TargetServers role.
Yup. That's totally intuitively obvious.