Task Scheduling automatic exp's

[TechEd23]

Hi all,

Now I am running a daily backup using the exp fuction in command prompt. But I am trying to find out how I could use Task Scheduler in windows 2000 to run the code in command prompt for me.

It has been hinted that I may be able to create a batch file (.bat) and then schedule it to be run in the evening.

Has anyone here ever created one and could give me some pointers?

Or does anyone know of another way to schedule the backups??

Many thanks

Eddy

 

[jee]

Yes - you could write a batch file and do this. Quite simple actually:

Put something like this in your file:

rem Perform a full database export
    exp user/password parfile=dailyexport.fil

You can fancy it up with error handling, etc.

Then use the job scheduler to specify when the job (batch file) should be run and what Windows account to logon to, etc.