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
- bulkadmin
- dbcreator
- diskadmin
- processadmin
- public
- securityadmin
- serveradmin
- setupadmin
- sysadmin
Please advise me.
It isn't a server role.
It is one of the "SQL Server Agent Fixed Database Roles" in msdb
See "How to: Configure a User to Create and Manage SQL Server Agent Jobs (SQL Server Management Studio)" on MSDN