标题: SQLSERVERAGENT 无法用批处理停止是怎么回事?? [打印本页]

---

作者: qwertl     时间: 2009-3-17 04:06    标题: SQLSERVERAGENT 无法用批处理停止是怎么回事??

ver:

Microsoft Windows 2000 [Version 5.00.2195]

C:\>net stop  SQLSERVERAGENT
.
SQLSERVERAGENT 服务无法停止。

---

作者: fn58     时间: 2009-5-1 22:30
@echo off
for /f "tokens=1-4 delims= " %%a in ('sc query MSSQLSERVER^|findstr "STATE"') do (
  if "%%d" neq "RUNNING" (
    sc config MSSQLSERVER start= demand
    sc start MSSQLSERVER
  ) else (
    sc stop MSSQLSERVER
  )
)