Integration Guide

Table Of Contents

PSS Software Installation

______________________________________________________________________________

WaveWorks PSS, Integration Guide, 1.10 Page 31

- In Starting At, change the time to 1:55am (or 5 minutes before backups will

be scheduled to start below).

- Press OK.

4.9.4 Configure the Extensive Database Check and Backup job

This step will configure a database backup, and an extensive check of the integrity of all of the

structures in the database, including tables and table indexes, which will run once a week. The

integrity check takes a relatively long time because the structure of all of the table indexes must

be verified, and because of this, this activity must be scheduled for the time of the week with the

least shopping activity.

- Under ‘Management’, click on ‘Database Maintenance Plans’.

- In the right pane, right-click, and select ‘New Maintenance Plan...’, and the Database

Maintenance Plan Wizard should appear. Click “Next.”

- This maintenance plan will include an exhaustive optimization and validation of the

database, as well as a backup. It should run once a week when the system is unused, or

lightly used. The default schedule for these activities is Sunday in the early morning

hours. You should change this schedule only if necessary.

- On the Select Databases page, make sure ‘These databases’ is selected, and check the box

next to the PSS database name. Click ‘Next’.

- On the ‘Update Data Optimization Information’ page, click on ‘Reorganize data and

index pages’, and click on ‘Remove unused space from database files’.

- This operation may take some time, and slow down the system, so if you have a

reason to use a different schedule, then next to ‘Schedule’ press the ‘Change’ button,

and make the appropriate changes.

- Click ‘Next’.

- On the ‘Database Integrity Check’ page, click on ‘Check database integrity’. Click on

‘Perform these tests before doing backups’.

- If you have a reason to use a different schedule, you can change it by pressing the

‘Change’ button next to ‘Schedule’. Make any changes, and press ‘OK”.