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

vw_sql_operations_status_controller_sql_operation_status

Name	Datatype	Description
id	text	Gets the Id.
name	text	Gets the operation name.
end_time	text	field from the properties object
error	text	Class for operation status errors.
operationStatusName	text	field from the properties object
resourceGroupName	text	field from the properties object
result	text	field from the properties object
siteName	text	field from the properties object
sqlSiteName	text	field from the properties object
start_time	text	field from the properties object
status	text	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. | | subscriptionId | text | field from the properties object |

sql_operations_status_controller_sql_operation_status

Name	Datatype	Description
id	string	Gets the Id.
name	string	Gets the operation name.
endTime	string	Gets the start time.
error	object	Class for operation status errors.
properties	object	Class for operation result 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

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

SELECT examples

Method to get operation status.

vw_sql_operations_status_controller_sql_operation_status

SELECT
id,
name,
end_time,
error,
operationStatusName,
resourceGroupName,
result,
siteName,
sqlSiteName,
start_time,
status,
subscriptionId
FROM azure.migrate.vw_sql_operations_status_controller_sql_operation_status
WHERE operationStatusName = '{{ operationStatusName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND siteName = '{{ siteName }}'
AND sqlSiteName = '{{ sqlSiteName }}'
AND subscriptionId = '{{ subscriptionId }}';

sql_operations_status_controller_sql_operation_status

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