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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Maintaining your database » Automating tasks 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 Developing event handlers.

 ♦  To 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 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:

  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.