Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » 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 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.