sqlwriter exesqlserver 如何禁用或启用其他服务器上的作业?

sqlserver 如何禁用或启用其他服务器上的作业?

1.禁用并停止SQL Server 相关服务 @ECHO ---------------------------------------- @ECHO 禁用SQL Server服务 @ECHO ---------------------------------------- @ECHO off sc config MSSQLSERVER start= DISABLED sc config MSSQL$SQLEXPRESS start= DISABLED sc config MSSQLServerOLAPService start= DISABLED sc config Smsftesql start= DISABLED sc config MsDtsServer start= DISABLED sc config ReportServer start= DISABLED sc config SQLWriter start= DISABLED echo 禁用SQL Server 相关服务 OK @ECHO ---------------------------------------- @ECHO 停止SQL Server服务 @ECHO MSSQL$ SQLWriter echo 停止SQL Server 相关服务 OK pause 把这段代码放进新建的记事本里面 保存为.cmd格式的就可以了 2.启用并启动SQL Server 相关服务 @ECHO ---------------------------------------- @ECHO 启用SQL Server服务 @ECHO ---------------------------------------- @ECHO off sc config MSSQLSERVER start= AUTO sc config MSSQL$SQLEXPRESS start= AUTO sc config MSSQLServerOLAPService start= AUTO sc config Smsftesql start= AUTO sc config MsDtsServer start= AUTO sc config ReportServer start= AUTO sc config SQLWriter start= AUTO echo 启用SQL Server 相关服务 OK @ECHO ---------------------------------------- @ECHO 启动SQL Server服务 @ECHO start start MSSQL$ start start start start start SQLWriter echo 启动SQL Server 相关服务 OK pause