<< Click to Display Table of Contents >> You are here: Administration > Job Poll Configuration > Scheduling a Job Poll Job > Database Maintenance Job Setup |
The Database Maintenance job poll job may be one of the most important jobs to be set up. This job backs up the Sage Paperless Construction SQL database to a defined location. This is important because a SQL database is a live, running system and it cannot be backed up by other means. Save the backup file produced by this job with other data/file backups in a safe and secure place. The Sage Paperless Construction system is comprised of SQL data and file data. Backing up both parts are critical to data safety in case the server crashes or has a catastrophic failure.
1.From the ribbon toolbar, click Administration.
2.Click Job Poll, .
The Job Poll Configuration screen similar to the following displays:
3.Click Add.
The Job Properties screen similar to the following displays:
Job Name |
Give the job a meaningful name. |
Job Type |
Select Database Maintenance from the Job Type dropdown list. |
Description |
Enter a description for the job. |
Active |
Click the Active check box to mark the job as Active. |
Schedule |
Determine how often the job should run. (every minute, hour, week, month, year) |
Schedule Job to run |
Depending on the schedule type, choose when the job should run. |
Beginning/Ending |
Set a beginning date and an ending date to run the job. |
Email on Success |
Check this box and enter an email address where an email will be sent if the job is successful. |
Email on Failure |
Check this box and enter an email address where an email will be sent if the job fails. |
Path |
Enter the path identifying the location of the database backup files stored on the SQL Server. |
4.Click OK to save the job.
5.On the Sage Paperless Construction Server Dashboard, click the Poll Service tab and make sure the Job Poll Service is installed and running.
Note: If the Job Poll Service is not running, the job will not run.