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 Understanding schedules.
System events are associated with a particular type of condition that is tracked by the database server. See Understanding 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.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|