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.

   A Create Schedule window pops up with following fields:

   • Repeat - To configure the repeat interval for your action. You can select any of these values from the dropdown list:

     • Does not repeat - The schedule runs only one time for the configured date and time.

       • Choose a start and stop day and time under the Duration.
     • Daily - The schedule runs daily on the configured time. To configure the end repetition schedule:

       • Select Never, if you don't want to end the repetition.
       • Select On and a date from the field below, if you want to end the repetition of the schedule on a particular date.
       • Select After and provide a number N in the field on the right side, if you want to end the repetition of the schedule after N occurrences.
       • Choose a start day and time under the Duration. Stop day and time depends on the choices you made in previous steps.
     • Weekly - The schedule runs weekly on the configured day and time.

       • Select the days you want to run the action in a week.

         To configure the end repetition schedule:
       • Select Never, if you don't want to end the repetition.
       • Select On and a date from the field below, if you want to end the repetition of the schedule on a particular date.
       • Choose a start day and time under the Duration. Stop day and time depends on the choices you made in previous steps.
2. After providing all the details, click Submit.

As an alternative method, use the code to configure Start/Stop schedule.

1. Click Code to view code of the generated schedule in different languages from the bottom of the window.

   The different languages supported for the code are Shell, Python, Go, Java, JavaScript, and PowerShell.
2. Copy and download the code in any of the languages using the copy and download button on the top right-side of the window.
3. Select Close to come back to the schedule window.

The configured schedules are listed below the Start/Stop Schedule option on this page. It displays:

• Start date - Displays the configured start date for the schedule.
• Duration - Displays the duration for which your database service is up and running.
• Repeat - Displays the schedule frequency. The possible values are Does not repeat, Daily, 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, transaction 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, transaction 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.

As an alternative method, use the code to configure the delete schedule.

1. Select Code to view code of the generated schedule in different languages from the bottom of the window.

   The different languages supported for the code are Shell, Python, Go, Java, JavaScript, and PowerShell.
2. Copy and download the code in any of the languages using the copy and download button on the top right side of the window.
3. Select Close to come back to the schedule window.

The configured delete schedules are displayed below the Delete Schedule option on this page. It displays:

Delete on - Displays the date and time when your database service is scheduled to delete. Also, it mentions if the Availability Machine is to be retained along with the service or not, 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 some other operation (patching, instance addition, parameter profile update, snapshot in progress, and so on). The database refresh is not triggered at the scheduled time and marked as SKIPPED.
• If there was no recent snapshot accessible to the schedule owner and the database refresh was triggered. In this case, the database refresh is marked as SKIPPED.