Menu
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
Please advise me.
778
In addition, there are only two ways that someone can have permission to execute a SQL Agent job. You must either own the job, or be a member of the role SQLAgentOperatorRole (MSDB).
If the owner is not a sysadmin, then the job runs under the owner's account. If the owner is sysadmin, then it runs under the SQL Server Agent service account.
Using SQL Server Management StudioIn Object Explorer, expand a server. Expand Security, and then expand Logins. Right-click the login you wish to add to a SQL Server Agent fixed database role, and select Properties. On the User Mapping page of the Login Properties dialog box, select the row containing msdb.
SQL Server Agent is a Microsoft Windows service that runs scheduled administrative tasks that are called jobs. You can use SQL Server Agent to run T-SQL jobs to rebuild indexes, run corruption checks, and aggregate data in a SQL Server DB instance.
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
133
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
