Contents Index ALTER DBSPACE statement ALTER FUNCTION statement

ASA SQL Reference
  SQL Statements

ALTER EVENT statement


Description 

Use this statement to change the definition of an event or its associated handler for automating predefined actions. Also, to alter the definition of scheduled actions.

Syntax 

ALTER EVENT event-name
DELETE TYPE | TYPE event-type ]
{      WHERE { trigger-condition | NULL }
   | { ADD | MODIFY | DELETE } SCHEDULE schedule-spec
}
ENABLE | DISABLE ]
[ [ MODIFY ] HANDLER compound-statement | DELETE HANDLER }

event-type :
  BackupEnd   | "Connect"
ConnectFailed  | DatabaseStart
DBDiskSpace | "Disconnect"
GlobalAutoincrement | GrowDB
GrowLog      | GrowTemp
LogDiskSpace   | "RAISERROR"
ServerIdle     | TempDiskSpace

trigger-condition :
event_condition( condition-name ) { = | < | > | != | <= | >= } value

schedule-spec :
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 ]

event-name | schedule-name :    identifier

day-of-week :        string

value | period | day-of-month :   integer

start-time | end-time :      time

start-date :         date

Parameters 

DELETE TYPE clause    Removes an association of the event with an event type. For a description of event types, see Choosing a system event.

ADD | MODIFY | DELETE SCHEDULE clause    Changes the definition of a schedule. Only one schedule can be altered in any one ALTER EVENT statement.

WHERE clause    The WHERE NULL option deletes a condition.

For descriptions of most of the parameters, see CREATE EVENT statement.

Usage 

This statement allows you to alter an event definition created with CREATE EVENT. Possible uses include the following:

Permissions 

Must have DBA authority.

Side effects 

Automatic commit.

See also 

BEGIN statement

CREATE EVENT statement


Contents Index ALTER DBSPACE statement ALTER FUNCTION statement