maintenance_window_options

Creates, updates, deletes, gets or lists a maintenance_window_options resource.

Overview

Name	maintenance_window_options
Type	Resource
Id	azure.sql.maintenance_window_options

Fields

vw_maintenance_window_options

Name	Datatype	Description
allow_multiple_maintenance_windows_per_cycle	text	field from the properties object
databaseName	text	field from the properties object
default_duration_in_minutes	text	field from the properties object
is_enabled	text	field from the properties object
maintenanceWindowOptionsName	text	field from the properties object
maintenance_window_cycles	text	field from the properties object
min_cycles	text	field from the properties object
min_duration_in_minutes	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
subscriptionId	text	field from the properties object
time_granularity_in_minutes	text	field from the properties object

maintenance_window_options

Name	Datatype	Description
properties	object	Maintenance window options properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	databaseName, maintenanceWindowOptionsName, resourceGroupName, serverName, subscriptionId	Gets a list of available maintenance windows.

SELECT examples

Gets a list of available maintenance windows.

vw_maintenance_window_options

SELECT
allow_multiple_maintenance_windows_per_cycle,
databaseName,
default_duration_in_minutes,
is_enabled,
maintenanceWindowOptionsName,
maintenance_window_cycles,
min_cycles,
min_duration_in_minutes,
resourceGroupName,
serverName,
subscriptionId,
time_granularity_in_minutes
FROM azure.sql.vw_maintenance_window_options
WHERE databaseName = '{{ databaseName }}'
AND maintenanceWindowOptionsName = '{{ maintenanceWindowOptionsName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

maintenance_window_options

SELECT
properties
FROM azure.sql.maintenance_window_options
WHERE databaseName = '{{ databaseName }}'
AND maintenanceWindowOptionsName = '{{ maintenanceWindowOptionsName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';