This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
0
I am working on a task that requires creation of a scheduled SQL Job. I am following the documentation here: https://learn.microsoft.com/en-us/sql/ssms/agent/configure-a-user-to-create-and-manage-sql-server-agent-jobs?source=recommendations&view=sql-server-ver16
Upon trying to access the SQL Server Agent by logging into the server via SSMS, I am unable to view the Agent. Searched about this issue on the web, I came across this: https://blog.sqlauthority.com/2018/11/29/sql-server-sql-server-agent-missing-in-sql-server-management-studio-ssms/
which says that one of the possible reasons may be that the Login account connecting to SSMS is not a part of SysAdmin role in SQL Server and thus SQL Server Agent would not be visible.
I thus ran the query -
Select IS_SRVROLEMEMBER('Sysadmin')
and got the output as 0 which meant that the login was not a Sysadmin. Read further and came across this link that talks about SQL Server Agent fixed database roles: https://learn.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?redirectedfrom=MSDN&view=sql-server-ver16.
Tried doing the following two things:
1.Creating a fresh login with sysadmin role - but unable to do so. Getting an error that I do not have permission.
ALTER ROLE SQLAgentUserRole ADD MEMBER <login name>
Again, getting the above error. Can someone please help me on this? Am I doing the right thing? Is there something I am missing?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.
If you are not the sysadmin on the server, you will have to talk with your DBA to get the required permission. Or ask the DBA to create the job for you.
As you may understand, it is not, and should not be, permitted to add yourself to role or grant yourself permissions.
Your step-by-step efforts to find a solution are commendable.
The error message in the screenshot you show may alert you that you do not have permission. So the core of the problem you encounter is that there is no permission.
Erland has given a solution. So you can refer to it.
Best regards,
Percy Tang