Run the SQL Job

• HBK_4700

  SSCrazy Eights

  Points: 8932

  More actions

  September 16, 2010 at 11:06 am

  #148695

  Hi,

  To run the SQL Server 2005 Job, what permissions a SQL Login needs to have?

  I need a specific user have only have permission to run the sql agent jobs.

  Thank you.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  September 16, 2010 at 11:11 am

  #1222404

  Please check these roles in MSDB

  SQLAgentUserRole

  SQLAgentReaderRole

  SQLAgentOperatorRole

  http://msdn.microsoft.com/en-us/library/ms188283.aspx

  Thank You,

  Best Regards,

  SQLBuddy