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

Event handlers execute on a separate connection from the action that triggered the event, and so do not interact with client applications. They execute with the privileges of the creator of the event.

Event handlers, whether for scheduled events or for system event handling, contain compound statements, and are similar in many ways to stored procedures. You can add loops, conditional execution, and so on, and you can use the SQL Anywhere debugger to debug event handlers.

After each execution of an event handler, a COMMIT occurs if no errors occurred. A ROLLBACK occurs if there was an error.

 Context information for event handlers
 Test event handlers
 Code sharing
 Debug event handlers
 Hide event handlers
 Limit active events
 See also

How the database server checks for system events
How the database server checks for scheduled events
How event handlers are executed
Creating a database event
Triggering an event handler
Debugging an event handler
Hiding an event handler