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