maintenances

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

Overview

Name	maintenances
Type	Resource
Id	azure.mysql.maintenances

Fields

Name	Datatype	Description
properties	object	The properties of a maintenance resource.

Methods

Name	Accessible by	Required Params	Description
list	SELECT	resourceGroupName, serverName, subscriptionId	List maintenances.
update	UPDATE	maintenanceName, resourceGroupName, serverName, subscriptionId	Update maintenances.
read	EXEC	maintenanceName, resourceGroupName, serverName, subscriptionId	Read maintenance.

SELECT examples

List maintenances.

SELECT
properties
FROM azure.mysql.maintenances
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

UPDATE example

Updates a maintenances resource.

/*+ update */
UPDATE azure.mysql.maintenances
SET 
properties = '{{ properties }}'
WHERE 
maintenanceName = '{{ maintenanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';