EXECUTE permission denied on object 'sp_start_job'

• shanila_minnu

  Hall of Fame

  Points: 3465

  More actions

  September 26, 2011 at 2:23 am

  #244401

  I am trying to run a sql agent job which Runs SSIS package that extracts employee data.However i am getting an error like "EXECUTE permission denied on object 'sp_start_job', database 'msdb', schema 'dbo'

• steveb.

  SSC-Forever

  Points: 46733

  More actions

  September 26, 2011 at 2:34 am

  #1386318

  I would check the permissions that your Agent is running and ensure that correct permissions to run the SSIS package have been applied.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 26, 2011 at 3:51 am

  #1386342

  In order to start a job, the user must be granted one of the fixed SQLAgent roles in msdb.

  See here for more info:

  http://msdn.microsoft.com/en-us/library/ms188283.aspx?ppud=4

  -- Gianluca Sartori