How to check SQL Server Agent is running

• Harikrishna Kanna

  SSC Enthusiast

  Points: 115

  More actions

  July 21, 2004 at 4:13 am

  #108570

  I have biult an application in VB .Net which creates job schedules in backend.For this SQL Server Agent should be running. How can i check whether SQL Server Agent is running and if not, start SQL Server Agent using code. I'm using MSDE 2000 as backend.

  Thanks in advance

  hari

• Azzam Alkadi

  SSChasing Mays

  Points: 640

  More actions

  July 22, 2004 at 2:58 am

  #515609

  I would use VB services ActiveX component and query the service status and start it if need be.