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.
| 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? | |
| What connection do event handlers get executed on? | How event handlers are executed |
| How do event handlers get information about what triggered them? |
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |