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

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
allowMultipleMaintenanceWindowsPerCycle	boolean	Whether we allow multiple maintenance windows per cycle.
defaultDurationInMinutes	integer	Default duration for maintenance window.
isEnabled	boolean	Whether maintenance windows are enabled for the database.
maintenanceWindowCycles	array	Available maintenance cycles e.g. {Saturday, 0, 4860}, {Wednesday, 0, 2460}.
minCycles	integer	Minimum number of maintenance windows cycles to be set on the database.
minDurationInMinutes	integer	Minimum duration of maintenance window.
systemData	object	Azure Resource Manager metadata containing createdBy and modifiedBy information.
timeGranularityInMinutes	integer	Time granularity in minutes for maintenance windows.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, server_name, database_name, subscription_id, maintenanceWindowOptionsName		Gets a list of available maintenance windows.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
database_name	string	The name of the database. Required.
maintenanceWindowOptionsName	string	Maintenance window options name. Required.
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
server_name	string	The name of the server. Required.
subscription_id	string

SELECT examples

get

Gets a list of available maintenance windows.

SELECT
id,
name,
allowMultipleMaintenanceWindowsPerCycle,
defaultDurationInMinutes,
isEnabled,
maintenanceWindowCycles,
minCycles,
minDurationInMinutes,
systemData,
timeGranularityInMinutes,
type
FROM azure.sql.maintenance_window_options
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND server_name = '{{ server_name }}' -- required
AND database_name = '{{ database_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
AND maintenanceWindowOptionsName = '{{ maintenanceWindowOptionsName }}' -- required
;