Contents Index Scheduling and event handling tasks Adding a manually-triggered event to a database

ASA Database Administration Guide
  Automating Tasks Using Schedules and Events
    Scheduling and event handling tasks

Adding a schedule or event to a database


Schedules and events are handled in a similar fashion, both from Sybase Central and in SQL.

For more information, see Understanding schedules, and Understanding events.

To add a schedule or event to a database (Sybase Central)

  1. Connect to the database as a user with DBA authority.

  2. Open the Events folder for your database.

  3. click the New Event button on the toolbar. The Event Creation wizard appears.

  4. Follow the instructions in the wizard.

    The wizard contains many options, depending on the schedule or event you wish to create. These are explained in detail in other tasks.

To add a schedule or event to a database (SQL)

  1. Connect to the database as a user with DBA authority.

  2. Execute a CREATE EVENT statement.

    The CREATE EVENT statement contains many options, depending on the schedule or event you wish to create. These are explained in detail in other tasks.

    For more information, see CREATE EVENT statement.


Contents Index Scheduling and event handling tasks Adding a manually-triggered event to a database