Changes the definition of an event or its associated handler for automating predefined actions. Also alters the definition of scheduled actions.
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 | IQMainDBSpaceFree | IQTempDBSpaceFree | 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 ]
SELECT event_id, event_name FROM SYS.SYSEVENT
SELECT event_id, sched_name FROM SYS.SYSSCHEDULE
Change an event handler during development.
Define and test an event handler without a trigger condition or schedule during a development phase, and then add the conditions for execution using ALTER EVENT once the event handler is completed.
Disable an event handler temporarily by disabling the event.
When you alter an event using ALTER EVENT, specify the event name and, optionally, the schedule name.
Each event has a unique event ID. Use the event_id columns of SYSEVENT and SYSSCHEDULE to match the event to the associated schedule.
Automatic commit