Server Role to execute SQL Server Agent Jobs in SQ

2019-04-18 17:28发布

The users from other departments ask me to grant them to execute Schedule Jobs / SSIS in SQL Server Agent. At present, they cannot see SQL Server Agent tree in their ManagmentStudio. I think, it's because they don't have the rights to execute them.

So, I would like to know which server role should I give to them. I only want to give them minimum privileges. When I check the existing roles in my server, I could only see the following server roles

  1. bulkadmin
  2. dbcreator
  3. diskadmin
  4. processadmin
  5. public
  6. securityadmin
  7. serveradmin
  8. setupadmin
  9. sysadmin

Please advise me.

登录 后发表回答