SQL Anywhere® Server - Database Administration  > 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. Connect to your database as a user with DBA authority.

2. Double-click the Events folder for your database.

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.

   The Create Schedule wizard appears.

6. Follow the instructions in the wizard.