How do I change my SQL Server Agent service account?
In order to change this, simply right-click on the service and select Properties. On the Log On tab on the Properties window you will see the account credentials being used to run the service. You can update this by entering the desired service account name and password into the specified fields.
What is the SQL Server Agent account?
The SQL Server Agent service startup account defines the Windows account that SQL Server Agent runs as, as well as its network permissions. This topic describes how to set the SQL Server Agent service account with SQL Server Configuration Manager in SQL Server by using SQL Server Management Studio.
Can a user access SQL Server Agent-job Activity Monitor?
So my question is can I have an user that can access SQL Server Agent – Job Activity Monitor, but that user is not in the sysadmin group? Add the user to msdb and put them in the SQLAgentOperatorRole fixed database role. For more information see the Books Online topic How to: Configure a User to Create and Manage SQL Server Agent Jobs.
Can a user start and stop a SQL Agent?
The user will be able to start (as well as stop, enable, and disable) any SQL Agent job on that server. (This solution turned out to satisfy the original asker.)
How to create or execute SQL Server Agent jobs?
To configure a user to create or execute Microsoft SQL Server Agent jobs, you must first add an existing SQL Server login or msdb role to one of the following SQL Server Agent fixed database roles in the msdb database: SQLAgentUserRole, SQLAgentReaderRole, or SQLAgentOperatorRole.
How to grant permission to a user in SQL Server?
SQLAgentReaderRole members cannot change job ownership to gain access to jobs that they do not already own. Only the Jobs node in SQL Server Management Studio Object Explorer is visible to members of the SQLAgentReaderRole. SQLAgentOperatorRole is the most privileged of the SQL Server Agent fixed database roles.