|
Category: IQ: events
Events
Events can be used to automate regularly recurring tasks.
Three different event types are defined in IQ. On the condition that no error has occurred, a
COMMIT
is issued after each execution of an event handler.
If an error did occur, a
ROLLBACK
is executed.
Events which have already been created can be retrieved from the
system table
SYSEVENT.
SELECT event_id, event_name FROM SYSEVENT
Event types
Events can be separate into three different classes:
planned events, system events and manual events, which again can be divided into 14 separate events.
Planned events
are executed at predefined points in time. System events
relate to a certain type of condition and will be protocolled by
IQ
if the fulfill a certain condition for a
trigger
Manual events
are only executed through a statement in a
TRIGGER EVENT
The
CREATE EVENT
statement can define the following events:
-
BackupEnd
-
'Connect'
-
ConnectFailed
-
DatabaseStart
-
DBDiskSpace
-
'Disconnect'
-
GlobalAutoincrement
-
GrowDB
-
GrowLog
-
GrowTemp
-
LogDiskSpace
-
'RAISERROR'
-
ServerIdle
-
TempDiskSpace
|
