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



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.