1

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?

3

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.

1
  • Thanks a lot, I'm gonna read it now. If needed I make another question asking how to set it up.
    – Hikari
    Jul 24 '20 at 13:47

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.