Right to view jobs in SQL Agent

I've removed the System Administors role from my SQL 2000 login to prevent
accidental updates/changes to data. Now I can't see any of the jobs in SQL
Server Agent that are owned by dbo. How can I set up accounts so that they
don't have update rights to databases but do have read-only rights to the jo
b
scheduler?Add them to the TargetServersRole in msdb (assuming you are on SP3 or
higher) and you'll be able to view (but not modify) the jobs.
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Joel H" <JoelH@.discussions.microsoft.com> wrote in message
news:1216C851-0A92-4932-8F23-65F91083AFF6@.microsoft.com...
> I've removed the System Administors role from my SQL 2000 login to prevent
> accidental updates/changes to data. Now I can't see any of the jobs in
> SQL
> Server Agent that are owned by dbo. How can I set up accounts so that
> they
> don't have update rights to databases but do have read-only rights to the
> job
> scheduler?