SET SYSDATE=%YEAR%%MONTH%%DAY%
SET DATETIMEF=%HOUR%%MIN%%SECS%
SET LOG_FILE=compare_1-1_%SYSDATE%_%DATETIMEF%.log
set i=-1
if %ComputerName%==AAA set Parameter_file=..\parameter\edw002m_parameterD.txt
if %ComputerName%==BBB set Parameter_file=..\parameter\edw002m_parameterU.txt
if %ComputerName%==CCC set Parameter_file=..\parameter\edw002m_parameterP.txt
if %ComputerName%==DDD set Parameter_file=..\parameter\edw002m_parameterP.txt
echo %Parameter_file%
echo %data% %time% > %LOG_FILE%
echo %ComputerName% >> %LOG_FILE%
echo %Parameter_file% >> %LOG_FILE%
for /f "delims=" %%a in ('more ^< %Parameter_file%') do (
set/a i+=1 & for /f %%z in ('echo/%%i%%') do (
if "%%z"=="0" set MSSQL_NAME=%%a
if "%%z"=="1" set MSSQL_USER=%%a
if "%%z"=="2" set MSSQL_PWD=%%a
if "%%z"=="3" set EVOICE_SERVER=%%a
)
)
if "%%z"=="0" set MSSQL_NAME=AAA
if "%%z"=="1" set MSSQL_NAME=BBB
if "%%z"=="2" set MSSQL_NAME=CCC
echo %MSSQL_NAME%
echo --------------- SP 0 execution begining %time% -------------- >> %LOG_FILE%
sqlcmd -S%MSSQL_NAME% -U%MSSQL_USER% -P%MSSQL_PWD% -icompare_exec0.sp>> %LOG_FILE%
echo --------------- SP 0 execution end %time% -------------- >> %LOG_FILE%
goto check
:end_check
goto COPY_EVOICE
:end_COPY_EVOICE
goto exit
:check
if exist D:\EDW\log\*.* goto end_check
echo %date% %time% file not exist >> %LOG_FILE%
goto exit
:COPY_EVOICE
:exit
move %LOG_FILE% ..\log\
exit
--------------------------------------------------------------
>>>>>>>>>>>>>>自己转换的shell<<<<<<<<<<<<<<<<
--------------------------------------------------------------
SYSDATE=$(date +"%Y-%m-%d")
DATETIMEF=$(date +"%H%M%S")
LOG_FILE=compare_1-1_$SYSDATE$DATETIMEF.log
i=-1
if [$ComputerName=="AAA"]; then
Parameter_file=../parameter/edw002m_parameterD.txt
elif [$ComputerName=="BBB"]; then
Parameter_file=../parameter/edw002m_parameterU.txt
elif [$ComputerName=="CCC"]; then
Parameter_file=../parameter/edw002m_parameterP.txt
else [$ComputerName=="DDD"]; then
Parameter_file=../parameter/edw002m_parameterP.txt
fi
Sysdate=$(date +"%Y-%m-%d%H%M%S")
echo $Parameter_file
echo $Sysdate > $LOG_FILE
echo $ComputerName >> $LOG_FILE
echo $Parameter_file >> $LOG_FILE
for \f "delims=" %%a in ('more ^< $Parameter_file'); do (
set\a i+=1 & for \f %%z in ('echo\%%i%%'); do (
if ["%%z"=="0"]; then
MSSQL_NAME=%%a
elif ["%%z"=="1"]; then
MSSQL_USER=%%a
elif ["%%z"=="2"]; then
MSSQL_PWD=%%a
else ["%%z"=="3"]; then
EVOICE_SERVER=%%a
fi
)
)
if ["%%z"=="0"]; then
MSSQL_NAME=DEVW16005
elif ["%%z"=="1"]; then
MSSQL_NAME=UATW16059
else ["%%z"=="2"]; then
MSSQL_NAME=HQ0W16133
fi
echo $MSSQL_NAME
echo "--------------- SP 0 execution begining $time --------------" >> $LOG_FILE
sqlcmd -S$MSSQL_NAME -U$MSSQL_USER -P$MSSQL_PWD -icompare_exec0.sp>> $LOG_FILE
echo "--------------- SP 0 execution end $time --------------" >> $LOG_FILE
goto check
:end_check
goto COPY_EVOICE
:end_COPY_EVOICE
goto exit
:check
if exist D:/EDW/log/*.* goto end_check
echo $Sysdate file not exist >> $LOG_FILE
goto exit
:COPY_EVOICE
:exit
move $LOG_FILE ../log/
exit
>>>>>>>>>>>>>>>>>>>>>>>>请大神帮忙改正!!!<<<<<<<<<<<<<<<<<<<<<<
