question

sqlLearner 1 avatar image
sqlLearner 1 asked

MSDB Permission SQLOperatorRole

Problem: I want to give SQLAgentOperator permission to a specific user "TestUser" I think I am missing a step or something. I thought this was rather simple. I run this from a sysadmin account to grant the permission: use msdb EXECUTE sp_addrolemember @rolename = 'SQLAgentOperatorRole', @membername = 'TestUser' But when I run: Exec msdb.dbo.sp_update_job @job_name = 'TestJob', @enabled = 1; I get this error: > Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 67 The specified @job_name ('TestJob') does not exist. Also when I look at the TestUsers Properties-->User Mapping MSDB is not checked off
sql-servertsqljobsmsdb
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
sqlLearner 1 avatar image
sqlLearner 1 answered
I got this working today using the same procedure. Maybe I was too tired yesterday.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.