Stopping SQL Agent

• williamminor

  SSCommitted

  Points: 1664

  More actions

  March 23, 2007 at 1:22 pm

  #173022

  Is there a way to stop the SQL agent from inside a script or Stored Procedure?

   

  Thanks

  -WM

• neotokyo

  SSCertifiable

  Points: 7239

  More actions

  March 23, 2007 at 1:26 pm

  #696701

  xp_cmdshell 'net stop SQLSERVERAGENT'

  thats it.

  though you may need to enable the xp_cmdshell.

  _________________________

• williamminor

  SSCommitted

  Points: 1664

  More actions

  March 25, 2007 at 8:23 pm

  #696798

  Thanks for your help

   

  -WM