Events

You can automate routine tasks in SQL Anywhere by adding an event to a database, and providing a schedule for the event. SQL Anywhere supports three types of events:

  • Scheduled events   have an associated schedule and execute at specified times. See Schedules.

  • System events   are associated with a particular type of condition that is tracked by the database server. See System events.

  • Manual events   are fired explicitly using the TRIGGER EVENT statement. See Triggering an event handler.

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