Any event handler can be triggered manually, in addition to those occasions when it executes because of a schedule or system event. Triggering events manually can be useful during development of event handlers, and also, for certain events, in production environments. For example, if you have a monthly sales report scheduled, you might want to obtain a sales report for a reason other than the end of the month.
For more information about developing event handlers, see Developing event handlers.
Connect to the database as a user with DBA authority.
In the left pane, double-click Events.
Right-click the event and choose Trigger.
The event must be enabled before you can trigger it. To enable an event, right-click it and choose Enabled.
In the Parameters field, type a comma-separated list of parameters for the event. For example:
parameter=value,parameter=value |
Click OK.
Connect to the database as a user with DBA authority.
Execute the TRIGGER EVENT statement, supplying the name of the event. For example:
TRIGGER EVENT sales_report_event; |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |