Managed Instance Operations - Get

服務:

SQL Database

API 版本:

2023-08-01

取得受控實例上的管理作業。

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/managedInstances/{managedInstanceName}/operations/{operationId}?api-version=2023-08-01

URI 參數

名稱	位於	必要	類型	Description
managedInstanceName	path	True	string	受控實例的名稱。
operationId	path	True	string (uuid)
resourceGroupName	path	True	string	包含資源的資源群組名稱。 您可以從 Azure Resource Manager API 或入口網站取得此值。
subscriptionId	path	True	string	識別 Azure 訂用帳戶的訂用帳戶標識碼。
api-version	query	True	string	要用於要求的 API 版本。

回應

名稱	類型	Description
200 OK	ManagedInstanceOperation	已成功擷取指定的受控實例作業。
Other Status Codes	ErrorResponse	錯誤回應： *** 400 ManagedInstanceStoppingOrStopped - 實例處於停止/停止狀態時提交的衝突作業 400 ManagedInstanceStarting - 實例處於啟動狀態時提交的衝突作業 404 ServerNotInSubscriptionResourceGroup - 指定的伺服器不存在於指定的資源群組和訂用帳戶中。 404 SubscriptionDoesNotHaveServer - 找不到要求的伺服器 404 ResourceNotFound - 找不到要求的資源。

範例

Gets the managed instance management operation

範例要求

HTTP

GET https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations/00000000-1111-2222-3333-444444444444?api-version=2023-08-01

dotnet

using Azure;
using Azure.ResourceManager;
using System;
using System.Threading.Tasks;
using Azure.Core;
using Azure.Identity;
using Azure.ResourceManager.Sql;

// Generated from example definition: specification/sql/resource-manager/Microsoft.Sql/stable/2023-08-01/examples/GetManagedInstanceOperation.json
// this example is just showing the usage of "ManagedInstanceOperations_Get" operation, for the dependent resources, they will have to be created separately.

// get your azure access token, for more details of how Azure SDK get your access token, please refer to https://learn.microsoft.com/en-us/dotnet/azure/sdk/authentication?tabs=command-line
TokenCredential cred = new DefaultAzureCredential();
// authenticate your client
ArmClient client = new ArmClient(cred);

// this example assumes you already have this ManagedInstanceOperationResource created on azure
// for more information of creating ManagedInstanceOperationResource, please refer to the document of ManagedInstanceOperationResource
string subscriptionId = "00000000-1111-2222-3333-444444444444";
string resourceGroupName = "sqlcrudtest-7398";
string managedInstanceName = "sqlcrudtest-4645";
Guid operationId = Guid.Parse("00000000-1111-2222-3333-444444444444");
ResourceIdentifier managedInstanceOperationResourceId = ManagedInstanceOperationResource.CreateResourceIdentifier(subscriptionId, resourceGroupName, managedInstanceName, operationId);
ManagedInstanceOperationResource managedInstanceOperation = client.GetManagedInstanceOperationResource(managedInstanceOperationResourceId);

// invoke the operation
ManagedInstanceOperationResource result = await managedInstanceOperation.GetAsync();

// the variable result is a resource, you could call other operations on this instance as well
// but just for demo, we get its data from this resource instance
ManagedInstanceOperationData resourceData = result.Data;
// for demo we just print out the id
Console.WriteLine($"Succeeded on id: {resourceData.Id}");

To use the Azure SDK library in your project, see this documentation. To provide feedback on this code sample, open a GitHub issue

範例回覆

狀態碼:

200

{
  "properties": {
    "managedInstanceName": "sqlcrudtest-4645",
    "operation": "UpsertManagedServer",
    "operationFriendlyName": "UPDATE MANAGED SERVER",
    "percentComplete": 100,
    "startTime": "2019-12-06T11:08:44.49Z",
    "state": "Cancelled",
    "isCancellable": false,
    "operationSteps": {
      "totalSteps": "6",
      "currentStep": 2,
      "stepsList": [
        {
          "order": 1,
          "name": "Request validation",
          "status": "Completed",
          "stepEndTime": "2019-12-06T11:08:45.57Z",
          "stepStartTime": "2019-12-06T11:08:44.49Z",
          "timeElapsed": "0"
        },
        {
          "order": 2,
          "name": "Virtual Cluster resize/creation",
          "status": "Completed",
          "stepEndTime": "2019-12-06T11:23:05.47Z",
          "stepStartTime": "2019-12-06T11:08:46.05Z",
          "timeElapsed": "14"
        },
        {
          "order": 3,
          "name": "New SQL Instance Startup",
          "status": "Canceled",
          "stepEndTime": "2019-12-06T11:23:11.51Z",
          "stepStartTime": "2019-12-06T11:23:05.55Z",
          "timeElapsed": "0"
        },
        {
          "order": 4,
          "name": "Seeding database files",
          "status": "NotStarted"
        },
        {
          "order": 5,
          "name": "Preparing Failover and Failover",
          "status": "NotStarted"
        },
        {
          "order": 6,
          "name": "Old SQL Instance cleanup",
          "status": "NotStarted"
        }
      ]
    }
  },
  "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations/11111111-1111-1111-1111-111111111111",
  "name": "11111111-1111-1111-1111-111111111111",
  "type": "Microsoft.Sql/managedInstances/operations"
}

定義

名稱	Description
ErrorAdditionalInfo	資源管理錯誤其他資訊。
ErrorDetail	錯誤詳細數據。
ErrorResponse	錯誤回應
ManagedInstanceOperation	受控實例作業。
ManagedInstanceOperationParametersPair	受控實例作業的參數。
ManagedInstanceOperationSteps	受控實例作業的步驟。
ManagementOperationState	作業狀態。
ManagementOperationStepState
UpsertManagedServerOperationParameters
UpsertManagedServerOperationStepWithEstimatesAndDuration

ErrorAdditionalInfo

Object

資源管理錯誤其他資訊。

名稱	類型	Description
info	object	其他資訊。
type	string	其他信息類型。

ErrorDetail

Object

錯誤詳細數據。

名稱	類型	Description
additionalInfo	ErrorAdditionalInfo[]	錯誤其他資訊。
code	string	錯誤碼。
details	ErrorDetail[]	錯誤詳細數據。
message	string	錯誤訊息。
target	string	錯誤目標。

ErrorResponse

Object

錯誤回應

名稱	類型	Description
error	ErrorDetail	error 物件。

ManagedInstanceOperation

Object

受控實例作業。

名稱	類型	Description
id	string	資源標識碼。
name	string	資源名稱。
properties.description	string	作業描述。
properties.errorCode	integer (int32)	作業錯誤碼。
properties.errorDescription	string	作業錯誤描述。
properties.errorSeverity	integer (int32)	作業錯誤嚴重性。
properties.estimatedCompletionTime	string (date-time)	作業的預估完成時間。
properties.isCancellable	boolean	是否可以取消作業。
properties.isUserError	boolean	錯誤是否為用戶錯誤。
properties.managedInstanceName	string	執行作業的受控實例名稱。
properties.operation	string	作業的名稱。
properties.operationFriendlyName	string	作業的易記名稱。
properties.operationParameters	ManagedInstanceOperationParametersPair	作業參數。
properties.operationSteps	ManagedInstanceOperationSteps	作業步驟。
properties.percentComplete	integer (int32)	作業完成的百分比。
properties.startTime	string (date-time)	作業開始時間。
properties.state	ManagementOperationState	作業狀態。
type	string	資源類型。

ManagedInstanceOperationParametersPair

Object

受控實例作業的參數。

名稱	類型	Description
currentParameters	UpsertManagedServerOperationParameters	目前的參數。
requestedParameters	UpsertManagedServerOperationParameters	要求的參數。

ManagedInstanceOperationSteps

Object

受控實例作業的步驟。

名稱	類型	Description
currentStep	integer (int32)	目前作業步驟的數目。
stepsList	UpsertManagedServerOperationStepWithEstimatesAndDuration[]	作業步驟清單。
totalSteps	string	作業步驟總數。

ManagementOperationState

列舉型別

作業狀態。

值	Description
Pending
InProgress
Succeeded
Failed
CancelInProgress
Cancelled

ManagementOperationStepState

列舉型別

值	Description
NotStarted
InProgress
SlowedDown
Completed
Failed
Canceled

UpsertManagedServerOperationParameters

Object

名稱	類型	Description
family	string
storageSizeInGB	integer (int32)
tier	string
vCores	integer (int32)

UpsertManagedServerOperationStepWithEstimatesAndDuration

Object

名稱	類型	Description
name	string
order	integer (int32)
status	ManagementOperationStepState
stepEndTime	string (date-time)
stepStartTime	string (date-time)
timeElapsed	string