1、把下面的语句放到一个.bat指令文件中。
@echo off
if "%date:~11,14%"=="周一" (expdp username/password@v3 DIRECTORY=toone DUMPFILE=ls_Monday.dmp LOGFILE=Monday.log full=y version=11.2.0.1.0 REUSE_DUMPFILES=y COMPRESSION=all
)
if "%date:~11,14%"=="周二" (
expdp username/password@v3 DIRECTORY=toone DUMPFILE=ls_Tuesday.dmp LOGFILE=Tuesday.log full=y version=11.2.0.1.0 REUSE_DUMPFILES=y COMPRESSION=all
)
if "%date:~11,14%"=="周三" (
expdp username/password@v3 DIRECTORY=toone DUMPFILE=ls_Wednesday.dmp LOGFILE=Wednesday.log full=y version=11.2.0.1.0 REUSE_DUMPFILES=y COMPRESSION=all
)
if "%date:~11,14%"=="周四" (
expdp username/password@v3 DIRECTORY=toone DUMPFILE=ls_Thursday.dmp LOGFILE=Thursday.log full=y version=11.2.0.1.0 REUSE_DUMPFILES=y COMPRESSION=all
)
if "%date:~11,14%"=="周五" (
expdp username/password@v3 DIRECTORY=toone DUMPFILE=ls_Friday.dmp LOGFILE=Friday.log full=y version=11.2.0.1.0 REUSE_DUMPFILES=y COMPRESSION=all
)
if "%date:~11,14%"=="周六" (
expdp username/password@v3 DIRECTORY=toone DUMPFILE=ls_Saturday .dmp LOGFILE=Saturday.log full=y version=11.2.0.1.0 REUSE_DUMPFILES=y COMPRESSION=all
)
if "%date:~11,14%"=="周日" (
expdp username/password@v3 DIRECTORY=toone DUMPFILE=ls_Sunday.dmp LOGFILE=Sunday.log full=y version=11.2.0.1.0 REUSE_DUMPFILES=y COMPRESSION=all
)
2、在windows的定时任务里面设置每天执行一次就可以。