sql-dmo to start SqlServerAgent

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  May 26, 2002 at 2:45 pm

  #64117

  When I use sql-dmo to stop, then restart, a sql 7 server the SqlServerAgent doesn't restart. How can I force it to start using sql-dmo?

  TIA,

  Bill

  P.S. When I manually restart the SqlServerAgent, no problema.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  May 26, 2002 at 4:29 pm

  #429777

  Try this:

  Dim oserver As SQLDMO.SQLServer

  Dim oJobServer As SQLDMO.JobServer

  Set oserver = New SQLDMO.SQLServer

  oserver.LoginSecure = True

  oserver.Connect "servername"

  oserver.JobServer.Start

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter