Enabling and editing retry SQL connection in Exmon Data Governance

This guide shows how to enable or edit Exmon Data Governance to ensure database connections do not stop Exmon tasks from executing

Tasks that start in Exmon Data Governance require a connection to the database that stores information about the Exmon instance. When the task fails to connect to the database, for whatever reason, it can be good to enable the retry logic that Exmon provides.

To enable or edit the retry logic, follow these steps:

1. Open Exmon Data Governance client
2. Open Execution History under General -> Audit History -> Execution History
   
3. Here you can see all the servers (and in some cases local user machines) that execute ExmonDG tasks. At a minimum, you should want to enable the retry on the most common servers you see.
   1. An easy way to see the most common servers is by right-clicking the server name column header and selecting Group by this columns
      
4. Now connect to the servers you want to enable or edit the retry logic on through Remote Desktop or other similar tools
5. Find Exmon DG installation on the server. It is usually located under C:\Program Files\exMon\Bin
6. Open the file ExpectusConfig.config
7. Look for the values ExmonConnectionSleepSeconds and ExmonConnectionRetryCount
   1. If you find these values edit them for your needs. 'Retry count' is the number of times Exmon will try to connect to the database after a failure. 'Sleep seconds' is the number of seconds Exmon will wait between retries.
   2. If you do not find these values you can paste these values to the file:
          <add key="ExmonConnectionSleepSeconds" value="20"/>
          <add key="ExmonConnectionRetryCount" value="2"/>
      
      The file should then look similar to this:
      
8. When you have added this logic to the most common servers that execute ExmonDG, you are done and ExmonDG should now retry connecting to the database on failure.