Re: Enterprise Manager

From: Dinesh.T.K (tkdinesh_at_nospam.mail.tkdinesh.com)
Date: 08/20/03


Date: Wed, 20 Aug 2003 09:55:42 -0500


Larry,

I assume you meant sql jobs..

If so , just assign the user to the TargetServersRole in msdb.This role
would allow the user to only 'view' the sql jobs.

-- 
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Larry Krauss" <lkrauss@tecoenergy.com> wrote in message
news:008701c36729$391a2280$a101280a@phx.gbl...
> Is there any way to allow developers the ability to see
> scheduled tasks on sql 2000 server without making them an
> Admin?
>
> Thanks. Larry.
>
> Larry Krauss
> TECO Energy, Inc.
> lkrauss@tecoenergy.com