Category: IQ: events

ALTER EVENT

The ALTER EVENT statement modifies an event, which was defined using the CREATE EVENT statement. Modifications can be made for the definition of an event or its processing routines.

CREATE EVENT: Syntax

    ALTER EVENT event_name
      [ DELETE TYPE | TYPE event_typ
      { 
             WHERE { trigger_condition | NULL }
             | {ADD | MODIFY | DELETE} SCHEDULE schedule_declaration
           }
      [ ENABLE | DISABLE ]
      [ [ MODIFY ] HANDLER compound-statement | DELETE HANDLER ]

Parameter der Anweisung CREATE EVENT

event_name
This is a descriptor, i.e. the name of the event to be modified.

event_type:
This is the type of event. An event_type is one "case sensitive", predefined value from the list below. It can either be changed or activated and deactivated, depending on its current status.

• DBDiskSpace
• TempDiskSpace
• LogDiskSpace
• GrowDB
• GrowLog
• GrowTemp
• BackupEnd
• 'Connect'
• ConnectFailed
• 'Disconnect'
• DatabaseStart
• GlobalAutoincrement
• MirrorFailover
• MirrorServerDisconnect
• 'RAISERROR'
• ServerIdle

trigger_condition:
Defines the conditions required to start the event.

    event_condition(condition_name) { = | < | > | != | <= | >= } value

    [schedule_name] {START TIME start_time | BETWEEN start_time AND end_time}
      [EVERY period { HOURS | MINUTES | SECONDS }]
      [ON { (day_of_week, ... ) | (day_of_month, ...) }]
      [START DATE start_date]

day_of_week, day_of_month, value und period
must be of the datatype integer.

schedule_name
Is a descriptor for an event schedule, which can be chosen arbitrarily but must not contain blank characters.

start_date
Is a value of the datatype date.

start_time und end_time
Is a value of the datatype time.

ALTER EVENT: Parameter

DELETE
The DELETE clause removes the association of an event to an event type, as listed above.

{ADD | MODIFY | DELETE} SCHEDULE
An ALTER EVENT statement can have only one of these three parameters in its WHERE clause. They change the definition of a SCHEDULE.

WHERE
The WHERE clause deletes a condition if NULL is specified.

[ENABLE | DISABLE]
Activates or deactivates the condition for an event according to its WHERE clause.