Database Administrators Asked by Hikari on October 28, 2021
My Active Directory account is on an AD group that is on msdb’s SQLAgentOperatorRole. I’m able to list existing MSSQL Agent jobs, but I can only view their steps and schedules, I’m unable to edit them or create new.
I’m able to create new jobs, but on their step, when I select CmdExec, no proxy is listed.
If I remove this group from SQLAgentOperatorRole, no job is listed anymore.
When I log as sa I’m able to edit jobs and proxies are listed.
Am I missing something to be able to manage jobs?
See the documentation at https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?view=sql-server-ver15. It clearly states what you can do with this role. It does not include privileges to edit a job owned by somebody else, for instance.
Answered by Tibor Karaszi on October 28, 2021
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP