exec sp_help_job user account rights

Hi All,

Which access rights are required for one user to be able to get results from
the following:
exec msdb..sp_help_job @job_name = 'TEST',@job_aspect = N'job';

the same user can get the list of jobs from:
select * from sysjobs order by name

I can make it working only if I put the user into the sysadmin server role.
This is rather to much for a monitoring purpose.

Thank you,
Vladimir
.

Relevant Pages

  • print to a file with CUPS
    ... that would send jobs to a predefined postscript file. ... by using the command: ... Now, when i type 'lp -d tofile foo', the file foo is ... The only problem concerns the access rights, ...
    (comp.os.linux.setup)
  • Re: Giving access to manage sql jobs
    ... Do you want the user to be able to modify only his/her jobs or all people? ... He/She mus be a member of sysadmin server role otherwise you are going to ... > What permissions, and how, can I give them permissions without making them ...
    (microsoft.public.sqlserver.security)
  • Re: GK - Granting on all objects but not on JOBs ?????
    ... You have to be member of SYSADMIN server role or member of DB_OWNER role ... in MSDB database. ... procedures etc) and NOT on JOBs? ...
    (microsoft.public.sqlserver.security)