ASA Database Administration Guide
  Automating Tasks Using Schedules and Events

Introduction

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

You can automate routine tasks in Adaptive Server 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 e-mail 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.

Chapter contents 

This chapter contains the following material:

• An introduction to scheduling and event handling (this section).

• Concepts and background information to help you design and use schedules and event handlers:

  • Understanding schedules.

  • Understanding events.

• A discussion of techniques for developing event handlers:

  • Developing event handlers.

• Internals information:

  • Schedule and event internals.

• Step by step instructions for how to carry out automation tasks.

  • Scheduling and event handling tasks.

Questions and answers