Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Statements

ALTER DOMAIN statement Next Page

ALTER EVENT statement


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

Syntax

ALTER EVENT event-name
[ AT { CONSOLIDATED | REMOTE | ALL } ]
[ DELETE TYPE | TYPE event-type ]
{ WHERE { trigger-condition | NULL }
| { ADD | ALTER | DELETE } SCHEDULE schedule-spec }
[ ENABLE | DISABLE ]
[ [ ALTER ] 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

AT clause    Use this clause to change the specification regarding the databases at which the event is handled.

DELETE TYPE clause    Use this clause to remove an association of the event with an event type. For a description of event types, see Understanding system events.

ADD | ALTER | DELETE SCHEDULE clause    Use this clause to change the definition of a schedule. Only one schedule can be altered in any one ALTER EVENT statement.

WHERE clause    Use this clause to change the trigger condition under which an event is fired. The WHERE NULL option deletes a condition. For descriptions of most of the parameters, see CREATE EVENT statement.

Remarks

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
Standards and compatibility