let my expdp cmd can run every 6 hr

參考指令(reference command)

 

EXPDP USERID='sys/manar@TJKDA as sysdba' full=y directory=backupdmp dumpfile=DA%date:~0,4%%date:~5,2%%date:~8,2%.dmp logfile=DA%date:~0,4%%date:~5,2%%date:~8,2%.log version=11.2.0.1.0

 

 

現在可執行指令(It can be run by manually)

expdp system schemas=ECPSCMP dumpfile=DATA_PUMP_DIR:ecpscmp.dmp logfile=DATA_PUMP_DIR:ecpscmp.log job_name=exp_ecpscmp

 

 

 

修正成如下:after modify it ,do it save to expdp.bat and use windows scheduler to run it every

6 hour

 

expdp system schemas=ECPSCMP dumpfile=DATA_PUMP_DIR: DA%date:~0,4%%date:~5,2%%date:~8,2%.dmp logfile=DATA_PUMP_DIR: DA%date:~0,4%%date:~5,2%%date:~8,2%.log job_name=exp_ecpscmp