Schedule export jobs on windows os through .bat file

Export Batch file for windows

ECHO OFF
CLS
:MENU
ECHO.
ECHO ......................................................
ECHO PRESS 1,2,3,4,5, or 6 to select your task, or 7 to EXIT.
ECHO ......................................................
ECHO.
ECHO 1 - Export Full Backup (must be a dba to do full database export)
ECHO 2 - Import Full Backup (must be a dba to do full database import)
ECHO 3 - Export Specific Schema Backup
ECHO 4 - Import Specific Schema Backup
ECHO 5 - Export Specific Schema's Table Backup
ECHO 6 - Import Specific Schema's Table Backup
ECHO 7 - EXIT
ECHO.
SET dmp_file_loc=E:\MyJob\export_job\dump_bkpfile
SET log_file_loc=E:\MyJob\export_job\dump_logfile
set Today=%date:~10,4%%date:~4,2%%date:~7,2%
set Now=%time:~0,2%%time:~3,2%%time:~6,2%
set DOW=%date:~0,3%
SET /P M=Type 1, 2, 3, 4, 5, 6 or 7, then press ENTER:
IF %M%==1 GOTO EXPORTFull
IF %M%==2 GOTO IMPORTFull
IF %M%==3 GOTO ESSCH
IF %M%==4 GOTO ISSCH
IF %M%==5 GOTO ESCHTAB
IF %M%==6 GOTO ISCHTAB
IF %M%==7 GOTO EOF
:EXPORTFull
SET /P USR=Type UserName,then Press ENTER:
SET /P PWD=Type Password,then Press ENTER:
SET /P HSTR=Type Hoststring,then Press ENTER:
echo ======================================================================
echo Pressed Key : 1
SET dumpFileName=%dmp_file_loc%\exp_FullDB@%HSTR%_%TODAY%
SET ElogFileName=%log_file_loc%\exp_FullDB@%HSTR%_%TODAY%
echo Dumpfile=%dumpFileName%
echo Elogfile=%ElogFileName%
echo ======================================================================
Pause
exp %USR%/%PWD%@%HSTR% Full=Y consistent=y file=%dumpFileName% log=%ElogFileName%
GOTO MENU
:IMPORTFull
SET /P USR=Type UserName,then Press ENTER:
SET /P PWD=Type Password,then Press ENTER:
SET /P HSTR=Type Hoststring,then Press ENTER:
echo ======================================================================
echo Pressed Key : 2
SET dumpFileName=%dmp_file_loc%\exp_FullDB@%HSTR%_%TODAY%
SET IlogFileName=%log_file_loc%\imp_FullDB@%HSTR%_%TODAY%
echo Dumpfile=%dumpFileName%
echo Ilogfile=%IlogFileName%
echo ======================================================================
Pause
imp %USR%/%PWD%@%HSTR% file=%dumpFileName% log=%IlogFileName% ignore=Y
GOTO MENU
:ESSCH
SET /P USR=Type UserName,then Press ENTER:
SET /P PWD=Type Password,then Press ENTER:
SET /P HSTR=Type Hoststring,then Press ENTER:
echo ======================================================================
echo Pressed Key : 3
SET dumpFileName=%dmp_file_loc%\exp_%USR%_fullSchBkp@%HSTR%_%TODAY%
SET ElogFileName=%log_file_loc%\exp_%USR%_fullSchBkp@%HSTR%_%TODAY%
echo Dumpfile=%dumpFileName%
echo Elogfile=%ElogFileName%
echo ======================================================================
Pause
exp %USR%/%PWD%@%HSTR% consistent=y file=%dumpFileName% log=%ElogFileName%
GOTO MENU
:ISSCH
SET /P USR=Type UserName,then Press ENTER:
SET /P PWD=Type Password,then Press ENTER:
SET /P HSTR=Type Hoststring,then Press ENTER:
echo ======================================================================
echo Pressed Key : 4
SET dumpFileName=%dmp_file_loc%\exp_%USR%_fullSchBkp@%HSTR%_%TODAY%
SET IlogFileName=%log_file_loc%\imp_%USR%_fullSchBkp@%HSTR%_%TODAY%
echo Dumpfile=%dumpFileName%
echo Ilogfile=%IlogFileName%
echo ======================================================================
Pause
imp %USR%/%PWD%@%HSTR% file=%dumpFileName% log=%IlogFileName% ignore=Y
GOTO MENU
:ESCHTAB
SET /P USR=Type UserName,then Press ENTER:
SET /P PWD=Type Password,then Press ENTER:
SET /P HSTR=Type Hoststring,then Press ENTER:
echo ======================================================================
echo Pressed Key : 5
SET dumpFileName=%dmp_file_loc%\exp_%USR%_sPtabs@%HSTR%_%TODAY%
SET ElogFileName=%log_file_loc%\exp_%USR%_sPtabs@%HSTR%_%TODAY%
echo Dumpfile=%dumpFileName%
echo Elogfile=%ElogFileName%
echo ======================================================================
SET /P TAB=Type Tables,then Press ENTER:
Pause
exp %USR%/%PWD%@%HSTR% TABLES=%TAB% consistent=y file=%dumpFileName%
log=%ElogFileName%
GOTO MENU
:ISCHTAB
SET /P USR=Type UserName,then Press ENTER:
SET /P PWD=Type Password,then Press ENTER:
SET /P HSTR=Type Hoststring,then Press ENTER:
echo ======================================================================
echo Pressed Key : 6
SET dumpFileName=%dmp_file_loc%\exp_%USR%_sPtabs@%HSTR%_%TODAY%
SET /P dfile=%dmp_file_loc%\exp_%USR%_sPtabs@%HSTR%_%TODAY%(default dump file ),if
other then Enter (0 i.e zero):
if %dfile%==0 GOTO PISCHTAB
SET IlogFileName=%log_file_loc%\imp_%USR%_sPtabs@%HSTR%_%TODAY%
echo Dumpfile=%dumpFileName%
echo Ilogfile=%IlogFileName%
echo ======================================================================
Pause
imp %USR%/%PWD%@%HSTR% file=%dumpFileName% log=%IlogFileName% ignore=Y
GOTO MENU
:PISCHTAB
echo =============================hi==============================================
SET /P pdumpFileName=Type dumpfile name along with path,then Press ENTER:
SET pIlogFileName=%log_file_loc%\Uimport_sPtabs@%HSTR%_%TODAY%
echo Dumpfile=%pdumpFileName%
echo Ilogfile=%pIlogFileName%
echo ======================================================================
Pause
imp %USR%/%PWD%@%HSTR% file=%pdumpFileName% log=%pIlogFileName% ignore=Y
GOTO MENU