how tu run agent with cmd commmand

• Amaury

  Mr or Mrs. 500

  Points: 546

  More actions

  June 1, 2005 at 5:17 pm

  #109849

  Hello!

  Does anybody know how to run sqlserver agent, but not with the service manager, I mean with something as a cmd command ?

  Thanks!!!!

  
  

  L.I. Amaury C.R.

• Si

  SSCommitted

  Points: 1537

  More actions

  June 2, 2005 at 4:37 am

  #562461

  If you can get netsvc (comes with NT reskit I think), you can...

  NETSVC "SQLServerAgent" \\servername /start    <use stop to stop and query for status>

   

• metcald

  SSC Veteran

  Points: 201

  More actions

  June 2, 2005 at 5:45 am

  #562467

  Much easier way...

  net start sqlserveragent

  You want to stop it?

  net stop sqlserveragent

  

• Jeff Gray

  SSChampion

  Points: 10667

  More actions

  June 2, 2005 at 9:07 am

  #562579

  If you are trying to do this on an MSCS cluster, you should use the CLUSTER command with the RESOURCE sub-command.

  /just in case...

   

  hth JG

   

• Si

  SSCommitted

  Points: 1537

  More actions

  June 2, 2005 at 9:56 am

  #562623

  With netsvc you can run the command remotely from another machine, and get the option just to see the status.  Good for routine check scripts