Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - Database Administration » Maintaining your database » Automating tasks using schedules and events » Understanding schedules

 

Defining schedules

To permit flexibility, schedule definitions have several components to them:

  • Name   Each schedule definition has a name. You can assign more than one schedule to a particular event, which can be useful in designing complex schedules.

  • Start time   You can define a start time for the event, which is the time when execution begins.

  • Range   As an alternative to a start time, you can specify a range of times for which the event is active. The event occurs between the start and end time specified. Frequency is determined by the specified recurrence.

  • Recurrence   Each schedule can recur. The event is triggered on a frequency that can be given in hours, minutes, or seconds on a set of days that can be specified as days of the week or days of the month. Recurring events include an EVERY or ON clause.

You can define the schedule for an event in the CREATE EVENT statement, or using the Create Schedule Wizard.

For information about adding a schedule when creating an event, see CREATE EVENT statement.

 ♦  To create a schedule for an event (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to connect to your database as a user with DBA authority.

  2. Double-click Events.

  3. Double-click the event for which you want to create a schedule.

  4. Click the Schedules tab.

  5. From the File menu, choose New » Schedule.

  6. Follow the instructions in the Create Schedule Wizard.