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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Task automation using schedules and events » Event handlers

 

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.

Prerequisites

You must have the MANAGE ANY EVENT system privilege.

Context and remarks

Triggering events manually can be useful during the 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.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  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:

    parameter=value,parameter=value
  5. Click OK.

Results

The event handler is triggered.

 See also