Creating an ASA Event Handler

An ASA event handler can be invoked manually by trigger event statements or automatically, based on an occurrence of system event conditions or fixed schedules.

To create an ASA event handler, you must have an ASA connection profile open. See Creating an ASA Connection Profile.

Under an ASA connection profile in Database Explorer, right-click the Events folder and select New Event to launch the Create Event Handler Skeleton wizard.
In the Name field, enter the event name.
The Preview window automatically begins generating the appropriate template code for your stored procedure.
Select Disable Event to disable the event so that it does not execute when the scheduled time or triggering condition occurs. A trigger statement does not execute a disabled handler.
From the Execution Location drop-down, specify where the event is to be executed:
- ALL: The default value. All databases execute the event.
- CONSOLIDATED: Restricts the databases at which an event is handled.
- REMOTE: Restricts to remote sites the databases at which an event is handled.

For Trigger Type, select an option:

Trigger Type	Procedure
Manual	If you create an event handler without a schedule or system event to trigger it, it is executed only when triggered manually. Click Finish. The ASA scheduled event handler definition skeleton appears in SQL Editor.
Schedule	Click Next. The Provide the Schedule Information page appears. Click Add to display the Schedule page. In the Name field, enter the name of the schedule. Under the General tab, set the start time you want the event to trigger. Use the At button to specify an exact time, or select the Between button to enter a range within the day. Select Start Date, then click Change Date to display an Event Calendar dialog from which you can select a month and day, which must be greater than or equal to today's date. Click OK to return to the Schedule page. Under the Repeat tab, indicate how often the event should repeat. Select the Repeat Time check box to set the repeat frequency. Select Trigger Event On to choose the Day(s) of the Week option or the Days of the Month option. Use the scroll-down menus to select the days of the week or month you want the event to repeat. Click OK to complete the schedule. The Provide the Schedule Information page reappears. You can schedule more events by selecting Add and repeating the above process. When you are done specifying events, click Finish. The ASA scheduled event handler definition skeleton appears in SQL Editor.
Condition	Click Next. The Provide Optional Condition Information page appears. Select one of the predefined system events from the drop-down list above the table. (See the ASA documentation for detailed descriptions of system events.) Select the Condition and Operator from their respective drop-down lists. Enter the Value and click OK. When you are done adding conditions, click Finish. The ASA event handler definition skeleton appears in SQL Editor.

In the Comments field, document the purpose and application of your stored procedure.