Task automation using schedules and events

Many database administration tasks are best performed systematically. For example, a regular backup procedure is an important part of proper database administration procedures.

You can automate routine tasks in SAP Sybase IQ by adding an event to a database, and providing a schedule for the event. Whenever one of the times in the schedule passes, the database server runs a sequence of actions called an event handler.

Database administration also requires taking action when certain conditions occur. For example, it may be appropriate to email a notification to a system administrator when a disk containing the transaction log is filling up so that the administrator can handle the situation. These tasks too can be automated by defining event handlers for one of a set of system events.

• Events
  You can automate routine tasks in SAP Sybase IQ by adding an event to a database, and providing a schedule for the event. SAP Sybase IQ supports the following types of events:
• 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.
• System events
  SAP Sybase IQ tracks several system events. Each system event provides a hook on which you can hang a set of actions. The database server tracks the events for you, and executes the actions (as defined in the event handler) when the system event 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 privileges of the creator of the event.