Chapter 9 SQL Statements
437
TYPE clause The event-type is one of the listed set of system-defined
event types. The event types are case insensitive. To specify the conditions
under which this event-type triggers the event, use the WHERE clause.
♦
DiskSpace event types If the database contains an event handler for
one of the DiskSpace types, the database server checks the available
space on each device associated with the relevant file every 30 seconds.
In the event the database has more than one dbspace, on separate drives,
DBDiskSpace checks each drive and acts depending on the lowest
available space.
The LogDiskSpace event type checks the location of the transaction log
and any mirrored transaction log, and reports based on the least available
space.
The disk space event types require one of the following operating
systems:
♦ Windows 95 OSR2
♦ Windows 98
♦ Windows NT 4.0 or later
♦
Globalautoincrement event type This event fires when the GLOBAL
AUTOINCREMENT default value for a table is within one percent of
the end of its range. A typical action for the handler could be to request a
new value for the GLOBAL_DATABASE_ID option.
You can use the
event_condition
function with RemainingValues as
argument for this event type.
♦
ServerIdle event type If the database contains an event handler for the
ServerIdle type, the server checks for server activity every 30 seconds.
WHERE clause The trigger condition determines the condition under
which an event is fired. For example, to take an action when the disk
containing the transaction log becomes more than 80% full, use the
following triggering condition:
...
WHERE event_condition( ’LogDiskSpacePercentFree’ ) < 20
...
The argument to the event_condition function must be valid for the event
type.
You can use multiple AND conditions to make up the WHERE clause, but
you cannot use OR conditions or other conditions.
$ For information on valid arguments, see "EVENT_CONDITION
function" on page 335.
To Next Page
Loading...