OraCmd - Oracle access without client tool »

Download OraCmd Free Trial »

Execute database tasks at a specific time

You need create batch files to perform database tasks, like this:

OraCmd userid=scott/tiger@localhost:1521:xe task=unload table=jobs datafile="e:\temp\jobs.txt" delimiter="|" quote="'" header=y quit=y log="e:\temp\unload_jobs.log"

You may need to run a batch file at a specific time and/or at a certain time every day. Below is additional information about how to do this.

Microsoft Windows 2000, XP, Vista, 7 and 8 users

With the introduction of Microsoft Windows 98, Microsoft has included Scheduled Tasks, a software program designed to run any program, including batch files, at any time or any schedule you desire. To run Scheduled Tasks, follow the below steps.

  1. Click Start
  2. Click Programs
  3. Click Accessories, System Tools, and then Scheduled Tasks.

Once open, you'll be able to create your own custom task by clicking Add Scheduled Task, which will start you through the wizard, prompting you with what program you wish to execute, how often you wish to run it (daily, weekly, monthly, one time only, when my computer starts, and when I log on), the time you wish to run, and how often each day to run.