maintenances

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

Overview

Name	maintenances
Type	Resource
Id	azure.mysql.maintenances

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
properties	object	The properties of a maintenance

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	subscriptionId, resourceGroupName, serverName		List maintenances.
update	update	subscriptionId, resourceGroupName, serverName, maintenanceName		Update maintenances.
read	exec	subscriptionId, resourceGroupName, serverName, maintenanceName		Read maintenance.

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
maintenanceName	string	The name of the maintenance.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
serverName	string	The name of the server.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.

SELECT examples

list

List maintenances.

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

UPDATE examples

update

Update maintenances.

UPDATE azure.mysql.maintenances
SET 
data__properties = '{{ properties }}'
WHERE 
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND serverName = '{{ serverName }}' --required
AND maintenanceName = '{{ maintenanceName }}' --required
RETURNING
properties;

Lifecycle Methods

read

Read maintenance.

EXEC azure.mysql.maintenances.read 
@subscriptionId='{{ subscriptionId }}' --required, 
@resourceGroupName='{{ resourceGroupName }}' --required, 
@serverName='{{ serverName }}' --required, 
@maintenanceName='{{ maintenanceName }}' --required
;