SQL Server agent error

• anjan.ashok

  SSCrazy

  Points: 2783

  More actions

  July 15, 2008 at 10:02 am

  #184620

  SQL Server agent is showing like SQL Server agent(Actice Xps disabled)

  showing red down arrow

  wat to do

  but the service is showing running.

• abmore

  Hall of Fame

  Points: 3628

  More actions

  July 15, 2008 at 11:39 pm

  #843520

  Are you running any job which uses xp_cmdshell ?

  Regards,

  Abhijit

• Vidhya Sagar

  SSCrazy Eights

  Points: 8216

  More actions

  July 17, 2008 at 4:37 am

  #844259

  [font="Verdana"]You can enable agent xp's from SAC or through sp_configure.[/font]

  Regards..Vidhya Sagar
  SQL-Articles