Re: Accessing jobs in EM

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 13:54:33 -0700

There is no supported way to do this with Enterprise
Manager. The proxy account doesn't really come in to play
here. The system stored procedures involved in displaying
the job info in Enterprise Manager have checks for job owner
or sysadmin server role membership.

-Sue

On Fri, 21 Jan 2005 14:46:12 -0800, "Igor Marchenko"
<igormarchenko@hotmail.com> wrote:

>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: Nevermind: Problem Between the Chair and the Keyboard
    ... There is a situation where you can end up with deleted data from Enterprise ... If you increase a constraint level in a table using Enteprise ... Manager, and then apply the script that the table designer creates, you can ... >> Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Replication Problem
    ... I've registered the Remote Computer in my Enterprise ... "SQL Server Agent on 'MyComputer' currently uses the ... how can I use Enterprise Manager ... from another computer to configure Replication Scenario's ...
    (microsoft.public.sqlserver.replication)
  • Re: Launching Enterprise Manager
    ... I uninstalled and deleted the SQL Server Enterprise ... Manager file that was causing the message. ... I cannot launch Enterprise ...
    (microsoft.public.sqlserver.setup)
  • Re: Problems with ado
    ... See if you can create a database using SQL2000 Enterprise Manager ... If none can be seen by QA => QA damaged, uninstall SQL2000 and reinstall ...
    (microsoft.public.data.ado)
  • Re: Grouping / Categorizing resources in ERP
    ... RBS field in the Enterprise Global, and then populating an RBS value for ... everyone in your organization in the Enterprise Resource Pool. ... SoftDev manager ... then report on this information within a number of places in Project Server, ...
    (microsoft.public.project)