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 the following 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.
User trace events are used to log information about an application to an event tracing session. These events are visible to all connections to a database. See Event tracing and CREATE TEMPORARY TRACE EVENT statement.
After each execution of an event handler, a COMMIT occurs if no errors occurred. A ROLLBACK occurs if there was an error.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|