Tuesday, February 4, 2014

search newer file and add scheduler




In database server
C:\sql_dumps\sql_dump_script
create file  jiansen_filecheck.bat, which contains:
set datetimef=%date:~-4%%date:~-10,2%%date:~-7,2%
echo  %datetimef% >> filecheck_out.txt

forfiles /p  C:\uploads\file_repository  /s  /D +0 /C "cmd /c echo @path" >> filecheck_out.txt
i.e. get the file list created today and send to file filecheck_out.txt
create scheduler
schtasks /create /tn "check new file" /tr C:\sql_dumps\sql_dump_script\jiansen_filecheck.bat  /sc daily /st 23:00:00

change C:\sql_dumps\sql_dump_script\jiansen_ftp.bat to add filecheck_out.txt in ftp list
copy ftp_original.txt ftp1.txt
set datetimef=%date:~-4%%date:~-10,2%%date:~-7,2%
echo  mput re*%datetimef%*.sql >>ftp1.txt
echo y >>ftp1.txt
echo  mput ce*%datetimef%*.sql >>ftp1.txt
echo y >>ftp1.txt
echo bye >> ftp1.txt
ftp -s:ftp1.txt


to

 copy ftp_original.txt ftp1.txt
set datetimef=%date:~-4%%date:~-10,2%%date:~-7,2%
echo  mput re*%datetimef%*.sql >>ftp1.txt
echo y >>ftp1.txt
echo  mput ce*%datetimef%*.sql >>ftp1.txt
echo y >>ftp1.txt
echo put C:\sql_dumps\sql_dump_script\filecheck_out.txt >>ftp1.txt
echo bye >> ftp1.txt
ftp -s:ftp1.txt

No comments:

Post a Comment