sql_operations_status_controller_sql_operation_status

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

Overview

Name	sql_operations_status_controller_sql_operation_status
Type	Resource
Id	azure.migrate.sql_operations_status_controller_sql_operation_status

Fields

The following fields are returned by SELECT queries:

get

ARM operation completed successfully.

Name	Datatype	Description
id	string	Gets the Id.
name	string	Gets the operation name.
endTime	string	Gets the start time.
error	object	Gets the error.
properties	object	Operation status properties
startTime	string	Gets the start time.
status	string	Gets the status of the operation. ARM expects the terminal status to be one of Succeeded/ Failed/ Canceled. All other values imply that the operation is still running.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, siteName, sqlSiteName, operationStatusName		Method to get operation status.

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
operationStatusName	string	Operation status Arm Name.
resourceGroupName	string	The name of the resource group. The name is case insensitive.
siteName	string	Site name
sqlSiteName	string	SQL site name.
subscriptionId	string	The ID of the target subscription.

SELECT examples

get

Method to get operation status.

SELECT
id,
name,
endTime,
error,
properties,
startTime,
status
FROM azure.migrate.sql_operations_status_controller_sql_operation_status
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND siteName = '{{ siteName }}' -- required
AND sqlSiteName = '{{ sqlSiteName }}' -- required
AND operationStatusName = '{{ operationStatusName }}' -- required
;