The Database (DB) Maintenance Scheduler is where you establish a schedule times for the system to perform functions. Establish the parameters you desire here after first installing iMerchant. Then simply let the system perform the duties on the schedule you have defined.
Setup Directories
From the Main Menu, go to:
Tools >Administration >Database Maintenance >DB Maintenance Scheduler
- The DB Maintenance Scheduler window pops up.
- The top of the window allows you to choose your directories (locations) of your Backups your Reports
-
Backup: choose your directory by clicking on the Browse button to the right of the Backup field.
- We recommend that your backup directory be housed on an external storage device, which can be moved out of the building.
-
Report: choose your directory by clicking on the Browse button to the right of the Report field.
- We recommend choosing a Report directory on a machine other than your iMerchant server.
5 Procedures to Schedule
In the lower portion of the window you will find .
Full Database Backup: backs up the entire iMerchant database
Log Backup: backs up the iMerchant log file.
Check the Integrity of Database: checks to make sure that your iMerchant database is okay.
Rebuild all Index: makes sure that all indexes are kept in order.
Update Weekly and Monthly Information: is an End Of Day function that you can run via the EOD program, but it can be set to run automatically here.
- We highly recommend that you set this to run automatically every day, having the scheduler launch it just after midnight.
To the right of all 5 procedures you can set the Days of Maintenance, here you define the frequency (or day of the week) for the task in question to be run.
We recommend setting each procedure to Everyday
Backup Copy: indicates how many files should be kept in the Backup directory.
- If set to 1, only one file will be stored. When the next file is created, it will replace the file that had been in the folder.
- If you choose 5, then up to five files will be stored in the Backup Directory at the same time.
- Set this value to whatever you desire.
Report Copy: works identically to the Backup Copy field. The only difference is the Report Copy field pertains to the maximum number of files you want housed in the Report Directory at any one time for a given task (Type of Maintenance).
Run Manually
If you want or need to run the DB Maintenance Scheduler manually
- Click on the Run button to the right of the Choose Directory section.
We highly recommend setting up the program to run automatically every day via the Microsoft Windows Scheduler application.