Deny permission on particular job

• Suneetha_k

  SSC Veteran

  Points: 220

  More actions

  May 25, 2010 at 4:22 am

  #221906

  Hi,

  I am having many jobs in a sql server. i want to give execute permissions for only single job in the server. can we give execute permissions for a particular job in sql server?

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 25, 2010 at 10:38 am

  #1172227

  Do you want a login other than the SQL Agent account or a member of sysadmin to execute the job? See SQL Server Agent Fixed Database Roles in BOL.

  Greg