Re: Setup user to run jobs

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/12/03

  • Next message: Sue Hoegemeier: "Re: Newbie to security"
    Date: Wed, 12 Nov 2003 15:29:12 -0700
    
    

    Have the user own the jobs. You can find more on this in
    books online under sp_start_job.
    There are some undocumented work arounds but they often
    cause more problems then they solve. And being that they are
    undocumented and unsupported, you would be on your own when
    problems come up.

    -Sue

    On Wed, 12 Nov 2003 14:10:57 -0500, "Jeff"
    <jsanders@htp-inc.com> wrote:

    >We need to setup a user who can manually start and run jobs, but no be a
    >system administrator. This is a help desk support position. What specific
    >rights need to be assigned so that the user can see and start the jobs?
    >Thanks,
    > Jeff
    >


  • Next message: Sue Hoegemeier: "Re: Newbie to security"

    Relevant Pages

    • Re: Queue handling design pattern?
      ... Combined with multiple jobs "eating" from queue, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
      (comp.databases.ms-sqlserver)
    • Re: monitor backup jobs on MSDE
      ... You can set this up in the jobs themselves. ... notify_level options with sp_add_job in books online. ... >different notification possibilites with MSDE. ...
      (microsoft.public.sqlserver.dts)
    • Re: Execute/ Run SSIS jobs.
      ... To execute jobs, check books online for sp_start_job. ... If these jobs can run on a schedule, ...
      (microsoft.public.sqlserver.setup)

  • Quantcast