|
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.
Connect to your database as a user with DBA authority.
Double-click the Events folder for your database.
Double-click the event for which you want to create a schedule.
Click the Schedules tab.
From the File menu, choose New > Schedule.
The Create Schedule wizard appears.
Follow the instructions in the wizard.