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
질문됨 2달 전118회 조회
1개 답변
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
전문가
답변함 2달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠