Re: User that can run jobs

From: Evgeny Kleiman (ekleiman_at_mekorot.co.il)
Date: 06/28/05 

Date: Tue, 28 Jun 2005 13:50:12 +0200

Uri, thank you very much. The English analogue of my name is Eugene (?????)
but I prefer to stay Evgeny. Jenya is also all right

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:ObAWS58eFHA.2128@TK2MSFTNGP15.phx.gbl...
> John ( we called Evgeny in Russia) :-)
> You /DBA have create a proxy account . See BOL for more details
> Syntax
> xp_sqlagent_proxy_account
>
> {N'GET' | N'SET' | N'DEL ,
>
> N'agent_domain_name', N'agent_username', N'agent_password'
>
> }
>
> "Evgeny Kleiman" <ekleiman@mekorot.co.il> wrote in message
> news:%23GXOn18eFHA.3504@TK2MSFTNGP14.phx.gbl...
> > Thank very much to all who answered me. Uri, I am not DBA, so I need in
> more
> > detail instructions (unfortunately,
> > our DBA also don't know this theme): what operations should DBA execute
> > allowing to a user(that is not a member of the sysadmin fixed server
role)
> > to run job
> > Thank you
> > Evgeny
> >
> > "Uri Dimant" <urid@iscar.co.il> wrote in message
> > news:eHkqtL8eFHA.1600@tk2msftngp13.phx.gbl...
> > > Jenya
> > > Ih the user is not a member of sysadmin server role he/she can execute
> > jobs
> > > that he/she owns
> > > BOL says
> > > When the user ,
> > > sp_start_job will impersonate the SQL Server Agent proxy account,
which
> is
> > > specified using xp_sqlagent_proxy_account. If the proxy account is not
> > > available, sp_start_job will fail.
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Evgeny Kleiman" <ekleiman@mekorot.co.il> wrote in message
> > > news:uZ8B4F8eFHA.2728@TK2MSFTNGP10.phx.gbl...
> > > > Hello
> > > >
> > > > I need to define a user of SQL Server 2000 that could run jobs. At
> > > present
> > > > time I succeeded only in the case that the user has rights of system
> > > > administrator (in Enterprise Manager in Logins I click right on the
> user
> > > and
> > > > in Properties/Server Roles I check box System administrator). But it
’s
> > too
> > > > strong for my aim. Is there another solution?
> > > >
> > > > Thank you
> > > >
> > > > Evgeny
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: urlencode vs rawurlencode
    ... | This method was used to make query URIs easier to pass in systems ... in the query component of an HTTP URL. ... A URI may contain ... Syntax and Escaping", ...
    (comp.lang.php)
  • Re: Web authentication
    ... RFC 2396: Uniform Resource Identifiers (URI): Generic Syntax ... Server-based Naming Authority ... specified server on the Internet use a common syntax for the server ...
    (comp.lang.python)
  • Re: How to improve performance of the reports display while updating the table?
    ... Uri was saying that your select has an error in it, ... but you are using an OLD style syntax which is VERY prone to the ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ... did you mean that my result will be wrong after I use the nolock syntax? ...
    (microsoft.public.sqlserver.server)
  • Re: How to set Http Request Header?
    ... However 2396 is the standard for URI ... and it doesn't take precedence over specific RFCs. ... that's the syntax for /general/ URI. ... own syntax for http_URL that /does not/ follow the general pattern in 2396. ...
    (comp.lang.java.programmer)