Exact Globe+

Diagnose FAQ: How do I schedule diagnose to run as a background job?

Introduction

This document describes how you can schedule the Diagnose tool to run as a background job using the Windows Scheduled Tasks. Based on the given set of parameters, you can choose to customise how the Diagnose tool will run at a scheduled time.

Note:

• To be able to have the Diagnose tool send e-mails in silent mode, you need to define the e-mail settings at the tab Output at System ➔ General ➔ User settings.
• When the e-mail settings are set to Outlook and you are running the diagnose in silent mode, a message will be displayed “A program is trying to automatically send e-mail on your behalf. Do you want to allow this?". This is the Outlook E-mail Security Update providing additional levels of protection against malicious e-mail messages. The Advanced Security for Microsoft Outlook is an add-in program that allows the diagnose to send emails without any security system restrictions when using the Outlook setting. This free add-in can be downloaded at http://www.mapilab.com/outlook/security. Once installed, you can run the diagnose in silent mode. A message box will be displayed during the first time. Select Allow access, select the Always perform this action for this file check box, and then click OK. This ensures that the diagnose in silent mode can send emails without displaying the message box again. 

Description

To create the scheduled task, you need the Exact.Conversion.ConsistencyCheck.exe file. You can find this file in the bin folder of the Exact Globe+ installation.

To create the scheduled task, you can use the following syntax: Exact.Conversion.ConsistencyCheck.exe -rsqlservername -Ddatabasename -u -~ <parameters>

The following parameters are available: 

Example 1: Diagnose checking only: C:\Program Files\Exact Software\bin\Exact.Conversion.ConsistencyCheck.exe -rMySQLServer -D955 -u -~ -S
Example 2: Diagnose advanced mode checking only: C:\Program Files\Exact Software\bin\Exact.Conversion.ConsistencyCheck.exe -rMySQLServer -D955 -u -~ -S /A:1
Example 3: Diagnose advanced mode automatic repair: C:\Program Files\Exact Software\bin\Exact.Conversion.ConsistencyCheck.exe -rMySQLServer -D955 -u -~ -S /A:1 /R:1
Example 4: Diagnose with different module setting. For finance checks only: C:\Program Files\Exact Software\bin\Exact.Conversion.ConsistencyCheck.exe -rMySQLServer -D955 -u -~ -S /A:1 /R:1 /O:1
Example 5: Diagnose result auto send via email: C:\Program Files\Exact Software\bin\Exact.Conversion.ConsistencyCheck.exe -rMySQLServer -D955 -u -~ -S /A:1 /R:1 /O:1 -eEmailAddress@Domain.com
The email sent contains the summary of the diagnose results and the diagnose results in Microsoft Excel files are also attached in the email.

To create a scheduled task, follow these steps:

1. Open the task scheduler in Windows by typing Task scheduler in the Windows search box.
2. Create a new scheduled task by clicking Create Basic Task.
3. At the Name field, define a name for the task and click Next.
4.  In the next screen, select the frequency to execute the task. Then, click Next.
5.  Select the time and day for this task to start and click Next.
6. In the next screen, select Start a program, and then click Next.
7. Click Browse to select the Exact.Conversion.ConsistencyCheck.exe file in C:\Program Files\Exact Software\bin. At Add arguments (optional), append the syntax for the scheduled task. For instance: -rMySQLServer -D955 -u -~ -S
8. Click Next.
9. Click Finish to create the task.

The task will be executed under the username that created the scheduled task. If you want to run the task under a different username and/or execute the task when the user is not logged in, do these additional steps:

1. Right click the task and select Properties.
2. Click Change User or Group to select a different user.
3. Enable the setting Run whether user is logged on or not to make sure the task is also executed when the user is not logged in.