Re: To view scheduled jobs in Enterprise Manager?

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 03/10/05


Date: Wed, 9 Mar 2005 23:37:25 -0000

And make sure you're on SP3 or higher otherwise that role has more rights
than it needs.

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"marcmc" <marcmc@discussions.microsoft.com> wrote in message 
news:D187E155-52CE-4A76-82DA-5E46D8D981F0@microsoft.com...
> You can add him to the TargetServersRole on msdb. Microsoft do not support 
> it
> though.
>
> "SangHunJung" wrote:
>
>> Hello, group.
>> I locked down a SQL2000 server that all developers have a limited access 
>> to
>> production SQL2000 server.  Now, one of developer would like to check a
>> scheduled job and he won't see any job listed in E.M.  Where I can set so 
>> he
>> can see all scheduled jobs?  He registered with Windows Auth.  I don't 
>> mine
>> to grap all dev group assign to the server to see scheduled jobs.  Any 
>> advice
>> would be appreciated.
>>
>> SangHun 


Relevant Pages

  • RE: ADSI as linked server
    ... This is Mark, a SQL Server Engineer. ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.connect)
  • RE: xp_cmdshell, Access Denied, Further Investigation Reveals
    ... context in which the SQL Server service is running. ... xp_cmdshell will impersonate the SQL Server ... Agent proxy account, ... Microsoft Online Partner Support ...
    (microsoft.public.sqlserver.security)
  • RE: Sharpoint Error in SBS 2003
    ... > Have you upgraded the Sharepoint WMSDE to SQL server? ... > A supported hotfix is now available from Microsoft, ... > To resolve this problem immediately, contact Microsoft Product Support ...
    (microsoft.public.windows.server.sbs)
  • RE: VS2008 Server Explorer takes 45 seconds to connect to SQL2005
    ... lab to apply for a test environment with Windows Server 2008. ... //Use TCP protocol to connect to your SQL Server instance ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.connect)
  • RE: Could not establish a connection to the database
    ... Server 2005 on the machine, when creating a new ASP.NET application and use ... "Could not establish a connection to the database. ... trying to use the default SQL server provider, ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.vsnet.setup)