Summary

Regular maintenance procedures will help you optimise the performance of your database. However, each database is unique so your consultant may advise you run alternative or additional maintenance procedures.

Purging allows you to remove redundant data, and you can purge:

• Closed pays
• Actuals
• Rosters
• Audit logs
• Employee history
• Payroll transaction audit logs
• Payroll transactions.

Daily

Backup

Complete a daily backup of your database after you have been working in PayGlobal. You should also run a backup before you start work on a lengthy process.

See also: Restore and Maintain Backups - Deleting Backups.

Inbox and Sent Items folders

Delete all unnecessary reports or messages from the PayGlobal Inbox and Sent Items folders.

Weekly

Deleted Items folder

Permanently delete all reports and messages from the Deleted Items folder by selecting them, and then pressing Delete.

Reindex and Pack

After you empty the Deleted Items folder, run Reindex and Pack to regenerate the indexes, remove deleted items, and compact the database. This process reduces the size of the data folder and backup.

Purging Pays

When you open a new pay period, the Closed Pays to Purge from Current form appears and you have the option of purging earlier pay sequences. PayGlobal stores pay sequences by placing a copy of the transactions in the following tables:

• Current Allowance
• Current Deduction
• Historical Allowance
• Historical Deduction.

When you purge a pay sequence, PayGlobal removes the transactions from the Current tables. As a result, you cannot run some of the primary reports (Pay Period Calculation Listing and Employee Pay Slip Report) or any transaction reports on the purged sequence. However, you can run transaction history reports.

If you decide to purge pay sequences, then you should take a backup first. The pay opening process will take slightly longer as PayGlobal purges the pay sequences that you selected.

You can significantly reduce the size of your database by regularly purging data that you no longer use. Purging will reduce the time required to:

• Back up data
• Reindex data
• Access data - This improvement would be small because PayGlobal minimises the data that needs to be accessed to accomplish a particular task.

Quarterly

The frequency that you run these commands depends on:

• The number of audit logs that you generate in PayGlobal
• How much hard disk space you have available
• Your organisational preferences.

Run the following commands:

• Maintain Log Files - Deletes unnecessary audit logs.
• Maintain Backups - Allows you to delete old backups.
• Purge - Allows you to purge old data.

  Important: Always run Reindex and Pack after you delete files.