KBI 311632 Monitoring Argent Job Scheduler Database Using Argent for SQL Server

Version

Argent for SQL Server – All versions

Date

Wednesday, 14 March 2018

Summary

Argent Job Scheduler database outage may be left undetected for hours causing critical Jobs not getting submitted

In such case, the log file of Scheduling Engine, AJSMAIN_SQL_LOG.TXT, shows the following errors

Failed to open ODBC database using connection string

Exception captured: SQL Server does not exist or access denied

Technical Background

As a proactive measure, Argent for SQL Server can be used to check Argent Job Scheduler database Offline status

Argent for SQL Server can monitor Argent Job Scheduler database and alert once the database is found inaccessible

Offline status or accessibility of Argent Job Scheduler database can be monitored using ‘Offline Database Rule’ in Argent for SQL Server

This can be configured as shown in the screenshot below:




Click For Full Size

Resolution

N/A