http://www.sqlservercentral.com/blogs/mssqlfun/2013/01/09/the-execute-permission-was-denied-on-the-object-sp_start_job-database-msdb-schema-dbo-1/

Printed 2014/11/25 04:32PM

The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.

2013/01/09

Reblogged from MSSQLFUN:

Click to visit the original post
  • Click to visit the original post

Issue : Today I have read one issue over one forum, One user is having below 3 DB roles on MSDB but whenever user try to run SQL Agent job, it get below error message.

We have Checked that SQL Agent job related DB role is properly given to user. Also, Job is working fine by the use is having sysadmin roles.

Read more… 143 more words


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.