I need to grant permissions to a group of users to run a specific job,

when I have a look at the job

use msdb
sp_help_job @job_name='ADS Incremental Load Orders & Accounts'

enter image description here

then I can see the job runs several packages.

how can I find using T-SQL, all the users that have permissions to run this job?

  • The job can be run only by the job owner and sysadmin role members. – Dan Guzman Sep 16 '16 at 10:43
  • You could create a SP to run the Sql job and grant execute authority to the group of people - Lots of examples on the Internet if you search (sql server run job from stored procedure permissions) - here is just one example - dba.stackexchange.com/questions/10449/… – Scott Hodgin Sep 16 '16 at 10:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.