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|