sp_update_jobschedule

• david.alcock

  SSCertifiable

  Points: 6021

  More actions

  February 10, 2014 at 6:10 am

  #303954

  Is it right that you have to be a sysadmin role member to execute this sotred procedure in msdb. I have tried to grant execute, add to SQLAgent roles and it still fails with execute denied?

  Really dont want to make the login that needs this access a sysadmin?!

  Thanks

  D

  'Only he who wanders finds new paths'

• david.alcock

  SSCertifiable

  Points: 6021

  More actions

  February 10, 2014 at 8:16 am

  #1687558

  Right resolved, the account needed to be in the agent operator role, that with the execute rights has been enough to get me by.

  D

  'Only he who wanders finds new paths'