Post reply

Allow Users to Schedule SA-Owned Jobs

  • January 20, 2010 at 8:19 am

    #386144

    Is there any way to allow users to schedule a job that's owned by the sa user? Possibly a stored procedure where they can pass in the schedule ID, start date, start time and start step? Any suggestions would be appreciated.

    Thanks,

    Hari

  • January 20, 2010 at 8:06 pm

    #1106451

    You could create a sproc that starts the job - specify 'EXECUTE AS' in the definition of the sproc so that it runs as a user who is allowed to start jobs.

    Alternatively, you could grant the users access to MSDB and include them in SQLAgentOperatorRole. However, if you do choose this option, the users will be able to add/delete/start etc any job.

    Personally, I would you the first option (EXECUTE AS)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply