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 - Database Administration » Automating Tasks Using Schedules and Events

Automating Tasks Using Schedules and Events Next Page

Introduction to 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 SQL Anywhere 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 executes 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.

Questions and answers
To answer the question... Consider reading...
What is a schedule? Understanding schedules.
What is an event? Understanding events
What is a system event? Understanding system events
What is an event handler? Understanding event handlers
How do I debug event handlers? Developing event handlers
How does the database server use schedules to trigger event handlers? How the database server checks for scheduled events
How can I schedule regular backups? Understanding schedules.
What kind of system events can the database server use to trigger event handlers?

Understanding system events.

CREATE EVENT statement.

What connection do event handlers get executed on? How event handlers are executed.
How do event handlers get information about what triggered them?

Developing event handlers

EVENT_PARAMETER function [System]