Adding a manually-triggered event to a database

Adding a schedule or event to a database

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

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)

Connect to the database as a user with DBA authority.
Open the Events folder for your database.
Click the Add Event event button on the toolbar. The Event Creation wizard appears.
Type a name for the event, and click Next.
Select Manually, and click Next.
Type the SQL statements for your event handler, and click Next.
Select Enable this event, and select Execute at all Locations, and click Next.
Type a comment describing the event, and click Finish to add the event to the database.

If you wish to accept the default values for all remaining options, you can click Finish at an earlier stage in the wizard.

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.