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.
Use the SQL Anywhere 12 plug-in to connect to your database as a user with DBA authority.
Double-click the event for which you want to create a schedule.
Click the Schedules tab.
Click File » New » Schedule.
Follow the instructions in the Create Schedule Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|