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?

Improve this question

1 Answer 1

Reset to default
3

See the documentation at https://learn.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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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