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

Debugging an event handler

Debugging is a regular part of any software development. Event handlers can be debugged during the development process.

For more information on developing event handlers, see Developing event handlers.

For more information on using the debugger, see Debugging Logic in the Database.

To debug an event handler

1. Start the Adaptive Server Anywhere debugger.

   From the Start menu, choose Programs > Sybase SQL Anywhere 9 > Adaptive Server Anywhere 9 > Debug Database Objects.

2. In the Connections window, double-click All Connections.

3. In the Procedures window, double-click the event you wish to debug. The event definition appears in the Source window.

4. In the Source window, set a breakpoint.

5. From Interactive SQL or another application, trigger the event handler using the TRIGGER EVENT statement.

6. The execution stops at the breakpoint you have set. You can now use the debugger features to trace execution, local variables, and so on.