Schedules

The Schedules tab allows you to set up start/stop and delete schedules for your database service.

Start/Stop Schedule

To configure the Start/Stop schedule:

1. Click Add on the right side. The Create Schedule dialog box appears with the following fields:

   • Repeat — Configure the repeat interval for your action. The available values are:

     • Does not repeat — The schedule runs only once for the configured date and time. Choose a start and stop day and time under Duration.
     • Daily — The schedule runs daily at the configured time. To configure the end repetition:

       • Select Never to run indefinitely.
       • Select On and choose a date to end the repetition on a specific date.
       • Select After and provide a number N to end after N occurrences.
       • Choose a start day and time under Duration.
     • Weekly — The schedule runs weekly on the configured day and time.

       • Select the days to run the action each week.
       • To configure the end repetition, select Never, or On with a date.
       • Choose a start day and time under Duration.
2. After providing all the details, click Submit.

The configured schedules are listed below the Start/Stop Schedule option. The following information is displayed:

• Start date — The configured start date for the schedule.
• Duration — The duration for which your database service is up and running.
• Repeat — The schedule frequency. The possible values are Does not repeat, Daily, and Weekly.

Delete Schedule

To configure the delete schedule:

1. Select Add on the right side.

   A window pops up with fields, Deletion date and Deletion time, to configure when you want to delete your service.
2. Pick the deletion date using the calendar icon.
3. Pick the deletion time using the clock icon.
4. Select the Take a final snapshot before deletion check box to create a standalone manual snapshot at the scheduled deletion time. This snapshot is independent of the Availability Machine.

   • Specify a name in the Snapshot Name field, or use the auto-generated name.
5. Select whether to retain the Availability Machine using the Retain existing data in the Availability Machine check box.
6. If you select this check box, choose one of the following options:

   • All existing data (snapshots, backups, WAL logs and DAPs) — Availability Machine and all its current contents are retained and continue to age out per the existing RPO policy.
   • Starred snapshots & backups only — Retains only the snapshots and backups you have marked as starred. All other snapshots, backups, WAL logs, and DAPs are deleted. For more information, see Star a snapshot or backup.
7. If you clear the Retain existing data in the Availability Machine check box, the Availability Machine and the database service are both deleted at the scheduled time.

   Note: If you selected Take a final snapshot before deletion in step 4, that snapshot is retained independently, even if you clear this check box.
8. Select Submit.

The configured delete schedule is displayed below the Delete Schedule option, showing the Delete on date and time, and whether the Availability Machine is to be retained, and whether a final snapshot is scheduled to be taken.

Refresh schedule

Any existing refresh schedules are displayed in the schedules section of the cloned service. The schedule can be updated, paused, or deleted through the ellipsis icon.

• If a database service is running another operation (patching, instance addition, parameter profile update, snapshot in progress, and so on), the database refresh is not triggered at the scheduled time and is marked as SKIPPED.
• If no recent snapshot is accessible to the schedule owner when the refresh is triggered, the database refresh is marked as SKIPPED.

As an alternative method, use the code to configure start/stop/delete schedules.

1. Click the Code button at the bottom-right corner to view the Code for start/stop/delete schedule window.
2. On the left-hand side, view the API, its type, and the payload.
3. On the right-hand side, view the code in Shell, Python, Go, Java, JavaScript, and PowerShell.
4. Use the copy and download buttons to save the code.
5. Click Close to return to the schedules window.

Figure 1: Schedules tab