Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database maintenance » Task automation using schedules and events » 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, 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 Event handler development.

 Trigger an event handler (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

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

  3. Right-click the event and click Trigger.

    The event must be enabled before you can trigger it. To enable an event, right-click it and click Enabled.

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

  5. Click OK.

 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.