Automating Tasks Using Schedules and Events

This chapter describes how to use scheduling and event handling features of Sybase IQ to automate database administration and other tasks.

• Introduction to Scheduling and Event Handling
  Many database administration tasks are best carried out systematically.
• Schedules
  By scheduling activities you can ensure that a set of actions is executed at a set of preset times. The scheduling information and the event handler are both stored in the database itself.
• Events
  The database server tracks several kinds of system events. Event handlers are triggered when the system event is checked by the database server, and satisfies a provided trigger condition.
• Event Handlers
  Event handlers execute on a separate connection from the action that triggered the event, and so do not interact with client applications. They execute with the permissions of the creator of the event.
• Schedule and Event Internals
  This section describes how the database server processes schedules and event definitions.
• Scheduling and Event Handling Tasks
  This section collects together tasks related to automating schedules and events.