Sun N1 Service Provisioning System 5.2 Installation Guide

ProcedureHow to Create a Scheduled Task to Optimize the Database

Steps
  1. Open the Windows 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\ Service\ Provisioning\ System/5.2/server/bin/roxdbcmd 
    vacuumdb -h localhost -a -z”
    

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

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