Cisco Cisco Workload Automation 6.3 User Guide

Working with Microsoft SQL Events

Assigning an Alert Action to an Event

Selecting this option will limit the event monitor to being active only during the defined time windows that are listed 
here. If this option is not selected then the event monitor will always be active. This section lists multiple time 
windows that the event monitor will monitor for the defined conditions. Any number of time windows can be created 
via the 

 dialog.

 – A sequence number for the defined time window.

 – Designates the time that the event monitor will begin actively monitoring for the 

defined conditions. This is expressed in a 24 hour clock format of hours, minutes and seconds. 

 – Designates the time that the event monitor will stop actively monitoring for the 

defined conditions. This is expressed in a 24 hour clock format of hours, minutes and seconds.

Click 

 to add the new event.

Assigning an Alert Action to an Event

You can assign an Alert action to an event so you know when the event has triggered. You can use the following Microsoft 
SQL event variables:



 – The database user who triggered the event.



 – The database object that triggered the event.



 –The output of the event selected.

In the 

 pane, select 

to display the 

 pane.

Click the 

 button or right-click on the 

 pane and select 

 

 from the context menu to display the 

 dialog.

In the 

 field, enter a name for the alert.

From the 

 list, select the owner name.