Adding a schedule or event to a database

Schedules and events are handled in a similar fashion in SQL.

For background information, see “Understanding schedules”, and “Understanding events”.

StepsAdding 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 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” in Chapter 6, “SQL Statements,” in the Sybase IQ Reference Manual.