window 自动任务 exp

编辑 exp_1.bat

exp aaa/aaa@test tables=tt_area file=I:11tt_area%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=I:11tt_area%date:~0,4%%date:~5,2%%date:~8,2%.log

导出的结果是:tb_area20090918.dmp ,tb_area20090918.log

或者 set "ymd=%date:~0,4%%date:~5,2%%date:~8,2%"

set "ymd=%date:~0,4%"
set "mm=%date:~5,2%"
set "dd=%date:~8,2%"

exp aaa/aaa@test tables=tt_area file=I:11tt_area_%ymd%%mm%%dd%.dmp log=I:11tt_area_%ymd%%mm%%dd%.log

或者
set "ymd=%date:~0,4%%date:~5,2%%date:~8,2%"
exp aaa/aaa@test tables=tt_area file=I:11tt_area%ymd%.dmp log=I:11tt_area%ymd%.log

[@more@]

编辑 exp_1.bat

exp aaa/aaa@test tables=tt_area file=I:11tt_area%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=I:11tt_area%date:~0,4%%date:~5,2%%date:~8,2%.log

导出的结果是:tb_area20090918.dmp ,tb_area20090918.log

或者 set "ymd=%date:~0,4%%date:~5,2%%date:~8,2%"

set "ymd=%date:~0,4%"
set "mm=%date:~5,2%"
set "dd=%date:~8,2%"

exp aaa/aaa@test tables=tt_area file=I:11tt_area_%ymd%%mm%%dd%.dmp log=I:11tt_area_%ymd%%mm%%dd%.log

或者
set "ymd=%date:~0,4%%date:~5,2%%date:~8,2%"
exp aaa/aaa@test tables=tt_area file=I:11tt_area%ymd%.dmp log=I:11tt_area%ymd%.log

控制面板 -----&gt计划任务-----&gt新增计划任务，最后填入密码 就OK 啦

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/66233/viewspace-1027102/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/66233/viewspace-1027102/