Schedule Properties window: Recurrence tab

All the settings on this tab are optional.

This tab has the following components:

Repeat every   Select the interval between successive scheduled events. Selecting this option adds a SCHEDULE EVERY clause to the event definition.

Scheduled event times are calculated when the schedules are created, and again when the event handler completes execution. See CREATE EVENT statement.

Trigger on the following   Select this option and then choose either the Days of the Week or the Days of the Month options. Selecting this option adds a SCHEDULE ON clause to the event definition.

  • Days of the week   Select the day(s) of the week on which the selected event occurs by selecting the checkbox(s) beside the day(s).

  • Days of the month   Select the day(s) of the month on which the selected event occurs by selecting the checkbox(s) beside the day(s).

See also