Events

You can automate routine tasks by adding an event to a database, and providing a schedule or conditional trigger for the event. In a multiplex, an event is a global object that is shared across all nodes participating in the multiplex.

There are three types of events:

Scheduled events have an associated schedule and execute at specified times.
Conditional events are associated with a system event, and an optional list of conditions that is tracked by the database server.
Manual events can only be fired explicitly.

After each execution of an event handler, a COMMIT occurs if no errors occurred. A ROLLBACK occurs if there was an error.

Creating an Event
Create a new event, set to be triggered manually, by a schedule or by a system event and specific conditions.
Deleting an Event
Permanently delete an event and all associated event schedules and triggers.
Disabling an Event
Disable a currently enabled event.
Enabling an Event
Enable a currently disabled event.
Triggering an Event
Execute an event. You can trigger an event manually regardless of its type (manual, scheduled, or conditional). The TRIGGER EVENT statement can be called at any time for any event.
Generating Event DDL Commands
Display the SQL data description language for creating a new event. The SQL code can be a useful reference and training tool.
Viewing or Modifying Event Properties
Display or change the properties of the selected event.
Event Schedules
You can schedule an event to run at a specific date, time or duration, once or at a recurring interval. An event can have more than one schedule.
Event Privilege Summary
A list of the system privileges and object permissions required to complete the various event tasks.

Parent topic: Administer and Monitor SAP Sybase IQ