The SQL Server Agent tree on SSMS can not be seen

0

I am trying to give a user access to the SQL Server JOBs from the Managment Studio, however, even though I granted him the corresponding permissions he still does not see the SQL Server Agent Tree.

I am using the following script:

**USE msdb GO IF NOT EXISTS(SELECT name FROM sys.database_principals WHERE name = 'Test') BEGIN CREATE USER test FROM LOGIN test END GO ALTER ROLE SQLAgentUserRole ADD MEMBER test GO

GRANT ALTER ON ROLE::[SQLAgentOperatorRole] to test

use msdb go ALTER ROLE SQLAgentOperatorRole ADD MEMBER test GO**

Any idea why is this happened?

JMCR09
asked 2 months ago107 views
1 Answer
0

Hi JMCR09,

Can you please confirm what version of RDS SQL server are you using?

Please note that SQL Server Express doesn't include SQL Server Agent,

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver15#SSMS

profile pictureAWS
EXPERT
answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions