The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'. (Microsoft SQL Server, Error: 229)

  • I need to give developers access to create and run jobs in development. I have tried everything and still get this error. I've tried:

    Setting msdb to trusted, it already had db cross chaining enabled

    sql agent and credentials have sa rights

    the developer windows group has sql agent operator, user, dts operator user enabled to exec

    in addition to their own role with exc rights to sp_job procs

    HELP!

    This is SQL Server 2k5 build 4035 on a 64bit.

    ¤ §unshine ¤

  • Look up these roles in Books Online (BOL)

    SQLAgentUserRole

    SQLAgentReaderRole

    SQLAgentOperatorRole

  • Hi,

    Grant the Execute permission for that Stored Procedure Using right click Properties window...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply