When I arrived on today morning, A one of the User asked me, How do i run schedule batch file for Oracle Export command for windows 7 ?…I just showed How do we do? As a mind,I want to sharing with you also who don’t know how to schedule batch files.
I opened notepad, and wrote simple export command for a schema user like
exp test/test file=d:\test\dbtest.dmp log=d:\test\dblog.log consistent=y direct=y statistics=’none’
And save as a testdb.bat file.
Start –> All Programs –> Accessories –> Sytem Tools –> Task Scheduler
Task Scheduler Windows Appear, Hear Go to –> Actions –> Create Basic Task
Put your schdule Name like below
Choose Your schduler Action
Choose Start a Program
Schedule your time
Choose your batch file
Step 8 :
Review your schedule Task and Click Finsh.