Table of Contents

How-To Automate your Daily Close Out

Concept

This how-to guide will help you set up Control to automatically run a daily close out. The basic approach is as follows:

Cautions for Backing up the Databse

In this process, Control instructs SQL to start the backup. However, Control does not get confirmation back from SQL whether it was successful or not.

Since this process is run off-hours and without user interaction, it is important that you check the results periodically to make sure that you are getting new backups. Many things (most commonly a bad network path or a full drive) can prevent the backup from succeeding. The only way you will know with this configuration is if you check it.

Cyrious strongly recommends you store the backup on a different computer. The backup path in the setup options can be a UNC path.

As noted above, you will need to be sure that the temporary path, storage space and final destination is properly set in the System Setup/Backup Options setup page in Control.

Steps

1. Create a Macro to run your close out.

Select 1, 1

2. Schedule the Macro to automatically run on the server every evening.

3. Check that the backup is successful! Important Step

Source

Contributor: Cyrious

Date: 1/23/2017

Version: Control 5.7+