Accessing jobs in EM

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

Date: Fri, 21 Jan 2005 14:46:12 -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)
  • Non-Admi users accessing jobs in Enterpise Manager
    ... 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.server)
  • 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)
  • Re: A question about subprocess
    ... I've done this sort of thing in the past with fork and exec. ... To serialize the jobs on the machines, the easiest thing is to just send ... the commands all at once to a given machine, ...
    (comp.lang.python)