Create ftp batch script and add scheduler

In database serve,  database is dumped into every 11:55 pm
C:\sql_dumps\mysql_admin
with timestamp 20140204 (year month day) .

Under C:\sql_dumps\sql_dump_script,
file ftp_original.txt
open 137.82.***.***
username
password
lcd C:\sql_dumps\mysql_admin
cd dbfile

jiansen_ftp.bat
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

  Create task to run jiansen_ftp.bat every night night 11:58 pm
schtasks /create /tn "ftp to UBC2" /tr C:\sql_dumps\sql_dump_script\jiansen_ftp.bat  /sc daily /st 23:58:00

to check schedule tasks:
schtasks /QUERY /FO LIST   /V

Reference for schtasks in Windows 2003 server:
http://support.microsoft.com/kb/814596
 http://technet.microsoft.com/en-us/library/bb490996.aspx