for /F "tokens=2,3 delims= " %%a in ("%date%") do SET TODAYEX=%%afor /F "tokens=1,2,3 delims=/" %%a in ("%TODAYEX%") do SET TODAY=%%a%%b%%cSET BASEBACKPATH=%TODAY%EXP user/password@sci1 FILE=F:\SCAMS_DB_DMP\BAK%BASEBACKPATH%.DMP OWNER=user LOG=F:\filename\BAK%BASEBACKPATH%.log
写一个批处理,作一个计划任务就好了
写一个批处理,作一个计划任务就好了
cd E:\database
mkdir "Bak%DATE%"
cd "Bak%DATE%"
exp username/pwd@ehy owner=usename file=ehy.dmp log=ehyexp.log feedback=1000
cd ..
winrar a -r -df "Bak%DATE%" "Bak%DATE%"