best way for multiple non-admin users to execute a sql job

• Adam Durr

  SSCommitted

  Points: 1755

  More actions

  March 27, 2009 at 6:17 pm

  #202303

  I realize that having sa be the owner of the job is the best practice, but I need to allow multiple non-admin users to execute a job. What is the best way to do this? I can only seem to add one user to the owner role at a time.

  I dont want them to be able to execute all of the jobs just specific jobs.

  I looked at the sqlagent role, but that gives permissions for all jobs. I looked at owners of jobs, but I cannot seem to add more than one owner and groups would not show up when I tried adding them to the owner. I am stumped.

  Any help would be great 😀

  Adam Durr
  Remote DBA support
  www.bluegecko.net

• Adam Durr

  SSCommitted

  Points: 1755

  More actions

  March 28, 2009 at 3:48 pm

  #967946

  I found a way to do this. Create a custom error that executes each job you want the user to use.

  Then create a storedprocedure that raises the custom error and assign execute permission for each user on the stored procedure.

  Adam Durr
  Remote DBA support
  www.bluegecko.net