You can automate routine tasks in SAP Sybase IQ by adding an event to a database, and providing a schedule for the event. SAP Sybase IQ supports the following types of events:
- Scheduled events – have an associated schedule and execute at specified times.
- System events – are associated with a particular type of condition that is tracked by the database server.
- Manual events – are fired explicitly using the TRIGGER EVENT statement.
- 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.
After each execution of an event handler, a COMMIT occurs if no errors occurred. A ROLLBACK occurs if there was an error.