Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Task automation using schedules and events » Schedules


Schedule definition

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.

Creating a schedule for an event