In this monitoring type the program periodically executes the SQL statement, specified by the user, and checks whether the value of the first column in the first recordset row matches the users criteria:

This option can be used to monitor certain parameters of a third-party SQL-based system, such as billing system or a customer database. To use this monitoring type please specify the data source name pointing to the database you wish to monitor, user login and password that will be used to log into the database server and the SQL query that will be executed against the database.

You should also write the SQL query Alchemy Eye will use to run every time it will attempt to check the server availability. After executing the query the program will retrieve the value of the first row / first column of the result data set and compare it to the value specified by the user in the picture above. If the value retrieved from the database will meet the filter criteria specified by the user, the program will think that the server is up and running. If the filter criteria was not met after the query execution result, Alchemy Eye will alert the Network Administrator and add a record to the program's log file.