Skip to main content

recommended_action_sessions

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

Overview

Namerecommended_action_sessions
TypeResource
Idazure.maria_db.recommended_action_sessions

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
createinsertsubscriptionId, resourceGroupName, serverName, advisorName, databaseNameCreate recommendation action session for the advisor.

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.

NameDatatypeDescription
advisorNamestringThe advisor name for recommendation action.
databaseNamestringThe name of the database.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
serverNamestringThe name of the server.
subscriptionIdstringThe ID of the target subscription.

INSERT examples

Create recommendation action session for the advisor.

INSERT INTO azure.maria_db.recommended_action_sessions (
subscriptionId,
resourceGroupName,
serverName,
advisorName,
databaseName
)
SELECT
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ advisorName }}',
'{{ databaseName }}'
;