How to use DTM DB Event as monitoring tool for a set of databases

DTM DB Event
Watch your database easy

• Features • Revision History • On-line Documentation • Screenshots • Press releases • Downloads • Order

The user should make a few easy steps to use this tool for database or server monitoring. The following table describes each step:

Step	Description
Create new event	The event is a set of properties. These properties define database server to me monitored, event condition and optional action.
Define database connection	Each event has individual database conenction settings. That means you can watch a few different databases by different events. More information about connection options.
Define check	For the simplest way you can define something like "select 'dummmy value' ". If the server can't execute it, it is down or we deals with connectivity problem. In more complex case the user can specify condition like "SQL statement must be executed faster than 200 ms" or "number of rows in result set greater 5".
Define action (optional)	The action instructs DTM DB Event to do something if event happen. For example, run SQL script or external batch file, that sent e-mail to DBA.