SQL Server Monitor

Using SQL Monitors, you may periodically execute SQL queries against a database and generate a variety of notification options. SQL Monitors support default and named instances, and Windows and SQL Server authentication, making it easy to fit into your existing SQL security environment.

SQL Monitor Settings

•Query - Enter a SQL query to be executed by the monitor. An event will be triggered if the results are different from the last time the query was run.  Enter the SQL instance name in the Instance Name field if necessary.  Otherwise leave blank for the default instance.

•Logon - The SQL Monitor supports SQL Authentication and Mixed Mode Authentication.

•If you are using integrated (Windows) authentication, then check the Use Integrated Logon checkbox.

•If you are using SQL authentication, un-check the Use Integrated Logon checkbox, and enter the username and password ELM is to use when executing the Query.

Actions

•Warning 5538 - The SQL query results are different from the results the last time the query ran.

Categories

Displays the Monitoring Categories to which the Monitor is assigned. Click to select or deselect Monitoring Categories. Right click to create or edit Monitoring Categories.

Test Monitor

Test any Monitor Item against any Agent capable of running the Item using the drop-down and Test button on this dialog box. Testing a Monitor Item prior to putting it into production validates that the monitor item is configured properly. To test a monitor item:

1.Select the Agent you wish to test against from the drop-down list.

2.Click the Start Test button.

If the test was successful, you will receive a pop-up indicating this and the option to see detailed results of the test. If the test failed, detailed results of the test will automatically open in Notepad.

Schedule

Displays the Scheduled Interval and Scheduled Hours settings which control the frequency for the Monitor Item.

Scheduled Interval tab

Specify the interval at which the monitoring, polling or action is to occur. Depending on the Monitor Item type, Items can be scheduled in interval increments of Seconds, Minutes, Hours and Days. The Scheduled Interval is relative to the top of the hour or top of the minute. For example, if a Scheduled Interval is configured for 10 minutes, the Monitor Item will execute at hh:10:00, hh:20:00, hh:30:00, hh:40:00, hh:50:00, h1:00:00, etc. If a Scheduled Interval is configured for 15 seconds, the Monitor Item will execute at hh:00:15, hh:00:30, hh:00:45, hh:01:00, hh:01:15, etc.

Scheduled Hours tab

Select the days and/or hours this item is active. By default, the schedule is set to ON for all hours and all days. Mouse clicks toggle squares between ON and OFF. Clicking on an individual square will toggle the active schedule for that hour. Clicking on an hour at the top of the grid, or on a day of the week at the left of the grid will toggle the corresponding column or row. Keyboard equivalents are the arrow keys and the space bar.

Properties Tab

This read-only tab displays the properties of the selected object and the values for those properties.