managed_instance_operations

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

Overview

Name	managed_instance_operations
Type	Resource
Id	azure.sql.managed_instance_operations

Fields

vw_managed_instance_operations

Name	Datatype	Description
description	text	field from the properties object
error_code	text	field from the properties object
error_description	text	field from the properties object
error_severity	text	field from the properties object
estimated_completion_time	text	field from the properties object
is_cancellable	text	field from the properties object
is_user_error	text	field from the properties object
managedInstanceName	text	field from the properties object
managed_instance_name	text	field from the properties object
operation	text	field from the properties object
operationId	text	field from the properties object
operation_friendly_name	text	field from the properties object
operation_parameters	text	field from the properties object
operation_steps	text	field from the properties object
percent_complete	text	field from the properties object
resourceGroupName	text	field from the properties object
start_time	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object

managed_instance_operations

Name	Datatype	Description
properties	object	The properties of a managed instance operation.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	managedInstanceName, operationId, resourceGroupName, subscriptionId	Gets a management operation on a managed instance.
cancel	EXEC	managedInstanceName, operationId, resourceGroupName, subscriptionId	Cancels the asynchronous operation on the managed instance.

SELECT examples

Gets a management operation on a managed instance.

vw_managed_instance_operations

SELECT
description,
error_code,
error_description,
error_severity,
estimated_completion_time,
is_cancellable,
is_user_error,
managedInstanceName,
managed_instance_name,
operation,
operationId,
operation_friendly_name,
operation_parameters,
operation_steps,
percent_complete,
resourceGroupName,
start_time,
state,
subscriptionId
FROM azure.sql.vw_managed_instance_operations
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND operationId = '{{ operationId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

managed_instance_operations

SELECT
properties
FROM azure.sql.managed_instance_operations
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND operationId = '{{ operationId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';