ASA Database Administration Guide
  Automating Tasks Using Schedules and Events
    Scheduling and event handling tasks

Triggering an event handler

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, you may have a monthly sales report scheduled, but from time to time you may want to obtain a sales report for a reason other than the end of the month.

For more information on 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. Open the Events folder for your database.

3. Right-click the event you wish to trigger and choose Trigger from the popup menu. The Trigger Event dialog appears.

   The event must be enabled before you can select Trigger from the popup menu. You can enable the event on the General tab of the Event property sheet.

4. Supply any parameters the event handler requires, in the following form:

   parameter=value;parameter=value

   Click OK to trigger the event handler.

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

   For more information, see TRIGGER EVENT statement.