Database Maintenance Job Setup

<< 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 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, JobPollButton.
 
The Job Poll Configuration screen similar to the following displays:
 
JobPollConfigurationscreen-mh
 

3.Click Add.
 
The Job Properties screen similar to the following displays:
 
JobPropertieswindownew-mh

 

 

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 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.
 
JobPollDBBackupJobSetup