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
posta 2 mesi fa118 visualizzazioni
1 Risposta
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
ESPERTO
con risposta 2 mesi fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande