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.
Use the SQL Anywhere 12 plug-in to 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:
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;
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|