摘要:非Sysadmin role有權限查看agent job
msdb裡有三種固定的database role，可以讓不具有sysadmin role的使用者有權限存取Agent Job
-
SQLAgentUserRole
-
SQLAgentReaderRole
-
SQLAgentOperatorRole
USE [msdb]
GO
CREATE USER [ellie] FOR LOGIN [ellie]
GO
EXEC sp_addrolemember N'SQLAgentUserRole', N'ellie'
GO