후아..

디렉토리 파일 갯수 받아서 몇개이상일경우 ftp 로 파일 올리기

@echo off

setlocal

set YEAR=%date:~0,4%

set MONTH=%date:~5,2%

set DAY=%date:~8,2%

set HOUR=%time:~0,2%

set MINUTE=%time:~3,2%

dir e:\MailRoot\Queue | find /c "R" > e:\MailRoot\script\fcnt.txt

for /f "delims=" %%i in (e:\MailRoot\script\fcnt.txt) do (

if %%i GTR 1000  (

echo %%i 가 10보다 큽니다. 

call e:\MailRoot\script\sms.bat "[emailgw] emailgw Queue Count = %%i"

pscp.exe -pw ***** e:\MailRoot\script\emailgw.dat root@192.11.1.11:/root/sms

del e:\MailRoot\script\emailgw.dat

))

=============================================================================================================================

@echo off

e:

cd \MailRoot\script

set txt=Insert into em_tran (tran_pr, tran_phone, tran_callback, tran_status, tran_date, tran_msg)

echo %txt%  >> emailgw.dat

echo values(em_tran_pr.nextval, 'xxx-xxx-xxxx', 'xx-xxx-xxxx', '1', sysdate, '%1%' ); >> emailgw.dat

set txt=Insert into em_tran (tran_pr, tran_phone, tran_callback, tran_status, tran_date, tran_msg)

echo %txt%  >> emailgw.dat

echo values(em_tran_pr.nextval, 'xxxxxxxxxx', 'xx-xxx-xxxx', '1', sysdate, '%1%' ); >> emailgw.dat

rem set txt=Insert into em_tran (tran_pr, tran_phone, tran_callback, tran_status, tran_date, tran_msg)

rem echo %txt%  >> emailgw.dat

rem echo values(em_tran_pr.nextval, 'xxxxxxxxxxx', 'xx-xxxx-xxxx', '1', sysdate, '%1%' ); >> emailgw.dat

echo commit; >> e:\MailRoot\script\emailgw.dat