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

 

Creating a database event

Events allow you to automate routine tasks. You can create scheduled events, system events, and manual events.

Prerequisites

You must have either the MANAGE ANY EVENT or CREATE ANY OBJECT system privilege.

Context and remarks

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.

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

 Task
  1. Use the SQL Anywhere 16 plug-in to connect to the database.

  2. In the left pane, right-click Events and click New » Event.

  3. Follow the instructions in the Create Event Wizard.

Results

The event is added to the database.

 See also