ASA Database Administration Guide
Automating Tasks Using Schedules and Events
Understanding events
Adaptive Server Anywhere tracks several system events. Each system event provides a hook on which you can hang a set of actions. The database server tracks the events for you, and executes the actions (as defined in the event handler) when needed.
The available system events include the following:
Backup You can use the BackupEnd event type to take action at the end of a backup.
DatabaseStart The database is started.
Connection events When a connection is made (Connect) or when a connection attempt fails (ConnectFailed). You may want to use these events for security purposes.
Disconnect You can use the disconnect event to take action when a user or application disconnects.
Free disk space Tracks the available disk space on the device holding the database file (DBDiskSpace), the log file (LogDiskSpace), or temporary file (TempDiskSpace). This system event is not available on the following operating systems:
Windows 95 before OSR2
Windows CE
You may want to use disk space events to alert administrators in case of a disk space shortage.
File size The file reaches a specified size. This can be used for the database file (GrowDB), the transaction log (GrowLog), or the temporary file (GrowTemp).
You may want to use file size events to track unusual actions on the database, or monitor bulk operations.
SQL errors When an error is triggered, you can use the RAISERROR event type to take actions.
Idle time The database server has been idle for a specified time. You may want to use this event type to carry out routine maintenance operations at quiet times.