0

Trying to do a simple

GRANT EXECUTE ON OBJECT::dbo.sp_add_job TO [user]

GO

and I am getting

Msg 15151, Level 16, State 1, Line 1
Cannot find the object 'sp_add_job', because it does not exist or you do not have permission.

Completion time: 2023-03-20T13:48:36.6851327-04:00

I am sysadmin, and true enough, I cannot locate the SP, but I thought that the SP_Add_job was auto created, or was I incorrect?

0

1 Answer 1

1

Permissions to the Server Agent's procedures are given by adding user to one of the fixed database roles:

  • SQLAgentUserRole
  • SQLAgentReaderRole
  • SQLAgentOperatorRole

Granting execute permission on a specific procedure is incorrect.

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.