windows环境下远程调用进程（同一域下）-CSDN博客

因为项目中的MS-SQL 服务器需要每季度做安全检查，相比于登录每台server单个的执行，批量执行显得尤为的重要。
环境：WINDOWS ENTERPRISE SERVER 2008/2005，MS-SQL 2008/2012
工具：sqlshc(安全检测工具)；psexec(远程调用进程工具);XCOPY(可远程copy目录工具)
实现方式：1.采取笨办法先挨个远程调用示例如下：
#1.Unified Path
XCOPY /E C:\Health_Check_AUTO \\1.1.1.1\C$\Health_Check_AUTO\
#2.Upload the required CMD
XCOPY /E C:\Health_Check_AUTO\HC.bat \\1.1.1.1\C$\Health_Check_AUTO\
#3.Running the Batch
psexec \\1.1.1.1 C:\IBM_Health_Check_AUTO\hc.bat
4.Get the Results
XCOPY /E /y \\1.1.1.1\C$\Health_Check_AUTO\HISTORY\* C:\Health_Check_AUTO\output\
如上可以实现远程批量调用进程实现HC，缺点是完全没有变量的带入。
2.相对于linux环境，对于windows显得很陌生，尚未完全摸索出CMD中变量及其下循环中的局部变量的转换调用，故在调试脚本中出现了很多问题（尚未调通）
开发中。。。。
--------------------------------------------
:: %1 - Network path to file directory for Script and input file
if /i "%1" EQU "" (
    SET FileDirectory=%cd%
    ) ELse (
    SET FileDirectory=%1%
    )
:: SET LOCAL VAR
SETLOCAL ENABLEDELAYEDEXPANSION
SET CTIME=%date:~3,11%:%time:~0,5%
SET PTIME="%CTIME: =%"
SET PTIME="%PTIME:/=%"
SET PTIME="%PTIME::=%"
echo %PTIME%
SET RESULTFILE=%cd%\result%PTIME%.txt
SET INSTFILE=%cd%\instance.txt
SET RUNFILE="%cd%\HC.bat"
SET lhcfile="C:\Health_Check_AUTO\"
SET rfile="C$\Health_Check_AUTO\HISTORY\*"
SET lfile="C:\Health_Check_AUTO\output\"
echo ...............................PERFORMING THE DB HEALTH-CHECK BEGINNING at %date:~3,11% %time:~0,5% ............................. >>%RESULTFILE%
for /f %%a in ('type %INSTFILE%') do (
SET InstanceName=%%a
XCOPY /E %lhcfile% \\!InstanceName!\%lhcfile%
if !errorlevel! EQU 0 (
::echo ................................!InstanceName! Can not been establishing (1).................. >>%RESULTFILE%
) else echo ................................!InstanceName! Health-check been performed (1)................. >>%RESULTFILE%
XCOPY /E %RUNFILE% \\!InstanceName!\%lhcfile
if !errorlevel! EQU 0 (
echo ................................!InstanceName! Can not been establishing (2).................. >>%RESULTFILE%
) else echo ................................!InstanceName! Health-check been performed (2)................. >>%RESULTFILE%
psexec \\!InstanceName! %RUNFILE
if !errorlevel! EQU 0 (
echo ................................!InstanceName! Can not been establishing (3).................. >>%RESULTFILE%
) else echo ................................!InstanceName! Health-check been performed (3)................. >>%RESULTFILE%
XCOPY /E /y \\!InstanceName!\%rfile% %lfile%
if !errorlevel! EQU 0 (
echo ................................!InstanceName! Can not been establishing (4).................. >>%RESULTFILE%
) else echo ................................!InstanceName! Health-check been performed (4)................. >>%RESULTFILE%
)
echo ...............................PERFORMING THE DB HEALTH-CHECK END at %date:~3,11% %time:~0,5% ............................. >>%RESULTFILE%