How to create a Scheduled Task in Windows

How to create a Scheduled Task in Windows

1. Click on Control Panel

2. Double-click on Scheduled Tasks

3. Double-click on Add Scheduled Task

4. Click on Next

5. Click on Browse

6. Select the MSDEMoveBackup.bat file from the MSDE Management Console.

7. Then follow the wizard to configure the task as you wish. Make sure the backup will be finished when this file is executed. You MUST supply a valid Windows username and password for that task to work properly.

8. After you finish setting the scheduled task, you must edit the MSDEMoveBackup.bat batch file.

How to configure the batch file

To open the batch file, right-click on the file named MSDEMoveBackup.bat and click on edit.

The default path is: C:program filesposition technologyMSDE Management console.

The target directory must be shared and appropriate permission must be assigned to the windows

user. You then map the network drive on the source computer. Please contact your network

administrator or the Position Technology technical support department at support@postech.ca

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

:: (C) 1998 - 2003 Position Technology Inc. All rights reserved.

@ECHO OFF

:: 1- Set the source directory where your backup are store by MSDE utility. In this example,

the source directory is C:

CD C:

:: 2- Set the name of the Main database backup file. In this example, the Main database backup

filename is Centaur3Main.bak. So you must type the same filename you enter in MSDE

management.

Don't forget to type the same filename on the following two lines.

FOR /f 'tokens=2-4 delims=/ ' %%a in ('DATE/T') do SET NewMain=%%c_%%a_%%b_Centaur3Main.bak

rename Centaur3Main.bak %NewMain%

:: 3- Set the name of the Event database backup file. In this example, the Event database

backup filename is Centaur3Event.bak. So you must type the same filename you enter in

:: MSDE management.

Don't forget to type the same filename on the following two lines.

FOR /f 'tokens=2-4 delims=/ ' %%a in ('DATE/T') do SET NewEvent=%%c_%%a_%%b_Centaur3Events.bak

rename Centaur3Events.bak %NewEvent%

:: 4- Set the destination directory of your backup for both files. Each file can have a

different destination directory. In this example, the destination directory is

U:CentaurDBBackup and NetworkDriveCentaurBackup.

MOVE %NewMain% U:CentaurDBBackup

MOVE %NewEvent% NetworkDriveCentaurBackup