Friday, 5 February 2021

 @echo off

REM #---------------------------------------------------------

REM #---------------------------------------------------------

REM ############ Begin variable list ############

SET SERVER_LOC=/u01/app/oracle/product/siebel/sblsvr/siebsrvr/objects/

SET LOCAL_LOC=C:\Siebel\Client_1\OBJECTS\

SET SRF_NAME=siebel_sia

SET DATE_DELIM=/

SET DAYS_TO_KEEP_BACKUPS=14

REM ### VARIABLES FOR DOWNLOAD FROM UNIX ###

SET PUTTY_PATH="C:\Program Files\putty"

SET SRVR_USERNAME=orafmw

SET SRVR_PASSWORD=orafmw5s

SET SRVR_NAME=172.21.128.38

REM ############ End variable list ############


rem echo. Check if the Folder Folder already exists on this machine for ENU.

if exist %LOCAL_LOC%ENU\Backup (

echo. REM  Backup folder already exists for ENU

) else (

echo Creating backup folder for ENU

mkdir %LOCAL_LOC%ENU\Backup

)

echo .


REM Use the text parsing mode of the "for" command and the /T (Display Only)

REM switch on the date and time commands

for /F "tokens=1-4 delims=%DATE_DELIM% " %%i in ('date /t') do (

set _DAY=%%i

set _MONTH=%%j

set _YEAR=%%k

)


for /F "tokens=1-4 delims=: " %%i in ('time /t') do (

set _HOUR=%%i

set _MIN=%%j

set _AMPM=%%k

)


@echo Backing up exsiting srf - ENU

REN  %LOCAL_LOC%ENU\%SRF_NAME%.srf %SRF_NAME%_%_YEAR%%_MONTH%%_DAY%_%_HOUR%%_MIN%.srf

MOVE %LOCAL_LOC%ENU\%SRF_NAME%_%_YEAR%%_MONTH%%_DAY%_%_HOUR%%_MIN%.srf %LOCAL_LOC%ENU\Backup\

echo .


echo Downloading SRF - ENU

rem xcopy %SERVER_LOC%\ENU\siebel_sia.srf %LOCAL_LOC%ENU\ /Y

rem REN %LOCAL_LOC%ENU\siebel_sia.srf %SRF_NAME%.srf

cd %PUTTY_PATH%

pscp -pw %SRVR_PASSWORD% %SRVR_USERNAME%@%SRVR_NAME%:%SERVER_LOC%enu/siebel_sia.srf %LOCAL_LOC%enu

echo .


echo Removing Old Files

forfiles -p %LOCAL_LOC%ENU\backup\ -m siebel_sia* -d -%DAYS_TO_KEEP_BACKUPS% -c "cmd /C del /q @FILE"

echo.

dir %LOCAL_LOC%ENU\%SRF_NAME%.srf


echo .

echo DOWNLOAD COMPLETE!

pause