0

I recently changed the owner of a job from my user to sa. After the ownership change I am able to edit the Schedules and Notifications for the job. However all attempts to to create New, Insert, Edit, or Delete job steps result in the window closing with the error 'Access Denied'. I tried changing the owner back to my user and also granted my user the SQLAgentOperatorRole in msdb, but the 'Access Denied' error persists when changing job steps.

This error also occurs when creating a new job. It's impossible to Create a job step.

Any idea how to resolve this?

Thanks

enter image description here enter image description here

0

1 Answer 1

0

I though the problem was with SQL Server, but it appears to have been caused by some bug in SSMS. Rebooting my PC solved the problem.

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.