How to Create a Scheduled Task to Optimize the Database

Steps

1. Open the Windows 2000 Scheduled Tasks Folder.

   You can open the Scheduled tasks folder by clicking the Start menu, then clicking Programs -> Accessories -> System Tools -> Scheduled Tasks.

2. To create a new task, right click in the folder and select New -> Scheduled Task.

3. Name the task.

4. Double–click on the task to edit it.

5. In the Run field, type the following command on a single line:

   bash -c “/cygdrive/c/Program\ Files/N1\ Grid\ Service\ Provisioning\ System/5.0/server/bin/roxdbcmd vacuumdb -h localhost -a -z”

   c/Program\ Files/N1\ Service\ Provisioning\ System/5.0 is the directory in which you installed the Master Server.

6. In the Schedule tab, configure the task to run once a day.