Chapter 9 SQL Statements
387
ALTER EVENT statement
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.
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
Must have DBA authority.
Automatic commit.
"BEGIN statement" on page 404
Function
Syntax
Permissions
Side effects
See also
To Next Page
Loading...