Non-Admi users accessing jobs in Enterpise Manager

From: Igor Marchenko (igormarchenko_at_hotmail.com)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 14:45:29 -0800

Hello!

   I would like to allow non-admin users seeing all jobs (including ones
they do now own) in Enterpise Manager.SQL Profiler displays execution of
exec msdb..sp_help_job when querying job list. According to BOL: ' A user
who is not a member of the sysadmin fixed role can use sp_help_job to view
only the jobs he/she owns.'. I suppose xp_sqlagent_proxy_account wouldn't be
of any help in this case. Is this possible for non-admin users to see all
jobs?

Thanks,

Igor

Relevant Pages

  • Re: SETPROG LNKLST--problem or procedural error?
    ... EXEC PGM=modname behaves differently from ... other program accesses from initiated jobs? ... Batch jobs run in initiators and they ...
    (bit.listserv.ibm-main)
  • Re: How to kill jobs in "select * from DBA_DATAPUMP_JOBS"
    ... Now, I can't kill them. ... Oracle asks me Username:, and I put system. ... Is it any way to kill or delete the jobs showed in DBA_DATAPUMP_JOBS? ... exec dbms_scheduler.disable ...
    (comp.databases.oracle.server)
  • Accessing jobs in EM
    ... they do now own) in Enterpise Manager.SQL Profiler displays execution of ... exec msdb..sp_help_job when querying job list. ... According to BOL: ' A user ... only the jobs he/she owns.'. ...
    (microsoft.public.sqlserver.security)
  • RE: Recatalog IODF
    ... jobs. ... ,//STEP1 EXEC PGM=IDCAMS ... For IBM-MAIN subscribe / signoff / archive access instructions, ... send email to listserv@xxxxxxxxxxx with the message: GET IBM-MAIN INFO ...
    (bit.listserv.ibm-main)
  • Re: Search for a string using SORT
    ... jobs to do this in the past, ... Here's some compare JCL I've used that you might find interesting. ... //SORTSTEP EXEC PGM=SORT ... OFOCUS COLS 1101:1115 ...
    (comp.lang.cobol)