|
<< Click to Display Table of Contents >> Navigation: ELM Console (MMC) > Monitoring and Management > Agents and Monitors Library > All Monitors > SQL 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.
•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.
•Warning 5538 - The SQL query results are different from the results the last time the query ran.
Displays the Monitoring Categories to which the Monitor item is assigned. Click to select or deselect Monitoring Categories. Click New to create or Properties to Edit Monitoring Categories.
Displays the Agents to which the Monitor item is assigned. Click to select or deselect individual agents. Click New to deploy an agent or Properties to View/Edit an existing agent.
Displays the Scheduled Interval and Scheduled Hours settings which control the frequency for the Monitor Item.
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.
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.