Permission to view only jobs

Hi
what are the permissions to be given for sql user if I
want him to see only jobs listed in the jobs section
under sql agent.
I tried giving ready only permissions on msdb & execute
permissions on sp_help_jobhistory. But still user cant
see the jobs listed.
Help will be appreciated.
Thanks,
ManojPlace him in the TargetServersRole role in msdb. He will not be able to
create or alter jobs, but can see them all.
Russell Fields
"Manoj Gadhia" <manoj.gadhia@.upbna.com> wrote in message
news:178501c47bd2$4efdc8e0$a601280a@.phx.gbl...
> Hi
> what are the permissions to be given for sql user if I
> want him to see only jobs listed in the jobs section
> under sql agent.
> I tried giving ready only permissions on msdb & execute
> permissions on sp_help_jobhistory. But still user cant
> see the jobs listed.
> Help will be appreciated.
> Thanks,
> Manoj|||Thanks
It worked Great
Manoj
>--Original Message--
>Place him in the TargetServersRole role in msdb. He
will not be able to
>create or alter jobs, but can see them all.
>Russell Fields
>"Manoj Gadhia" <manoj.gadhia@.upbna.com> wrote in message
>news:178501c47bd2$4efdc8e0$a601280a@.phx.gbl...
execute[vbcol=seagreen]
>
>.
>