Adding a manually-triggered event to a database

If you create an event handler without a schedule or system event to trigger it, it is executed only when manually triggered.

To add a manually-triggered event to a database (Sybase Central)

Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
In the left pane, right-click Events and choose New » Event.
In the What Do You Want To Name The New Event field, type a name for the event and click Next.
Select Manually and click Next.
Select Enable This Event, Execute At All Databases, and then click Next.
Type a comment describing the event and click Finish.
In the SQL pane, type the SQL statements for your event.
From the File menu, choose Save.

To add a manually-triggered event to a database (SQL)

Connect to the database as a user with DBA authority.
Execute a CREATE EVENT statement with no schedule or WHERE clause. The restricted syntax of the CREATE EVENT is as follows:
```
CREATE EVENT event-name
HANDLER
BEGIN
... //event handler
END
```

If you are developing event handlers, you can add schedules or system events to control the triggering of an event later, either using Sybase Central or the ALTER EVENT statement.

Adding a manually-triggered event to a database

To add a manually-triggered event to a database (Sybase Central)

To add a manually-triggered event to a database (SQL)

See also