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.

♦  To trigger an event handler (Sybase Central)

1. Connect to the database as a user with DBA authority.

2. In the left pane, double-click Events.

3. 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.

4. In the Parameters field, type a comma-separated list of parameters for the event. For example:

   parameter=value,parameter=value

5. Click OK.

♦  To trigger an event handler (SQL)

1. Connect to the database as a user with DBA authority.

2. Execute the TRIGGER EVENT statement, supplying the name of the event. For example:

   TRIGGER EVENT sales_report_event;

   See TRIGGER EVENT statement.