你当前正在访问 Microsoft Azure Global Edition 技术文档网站。如果需要访问由世纪互联运营的 Microsoft Azure 中国技术文档网站，请访问 https://docs.azure.cn。

Managed Instance Operations - List By Managed Instance

参考

Service:: SQL Database

API Version:: 2021-11-01

获取在托管实例上执行的操作的列表。

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

URI 参数

名称	在	必需	类型	说明
managedInstanceName	path	True	string	托管实例的名称。
resourceGroupName	path	True	string	包含该资源的资源组名称。可以从 Azure 资源管理器 API 或门户获取此值。
subscriptionId	path	True	string	用于标识 Azure 订阅的订阅 ID。
api-version	query	True	string	要用于请求的 API 版本。

响应

名称	类型	说明
200 OK	ManagedInstanceOperationListResult	已成功执行获取托管实例操作的请求。
Other Status Codes		错误响应：*** 404 SubscriptionDoesNotHaveServer - 找不到请求的服务器 404 ServerNotInSubscriptionResourceGroup - 指定的服务器不存在于指定的资源组和订阅中。

名称

类型

说明

200 OK

ManagedInstanceOperationListResult

已成功执行获取托管实例操作的请求。

Other Status Codes

错误响应：***

404 SubscriptionDoesNotHaveServer - 找不到请求的服务器
404 ServerNotInSubscriptionResourceGroup - 指定的服务器不存在于指定的资源组和订阅中。

示例

List the managed instance management operations

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


import com.azure.core.util.Context;

/** Samples for ManagedInstanceOperations ListByManagedInstance. */
public final class Main {
    /*
     * x-ms-original-file:
     * specification/sql/resource-manager/Microsoft.Sql/stable/2021-11-01/examples/ListManagedInstanceOperations.json
     */
    /**
     * Sample code: List the managed instance management operations.
     *
     * @param azure The entry point for accessing resource management APIs in Azure.
     */
    public static void
        listTheManagedInstanceManagementOperations(com.azure.resourcemanager.AzureResourceManager azure) {
        azure.sqlServers().manager().serviceClient().getManagedInstanceOperations()
            .listByManagedInstance("sqlcrudtest-7398", "sqlcrudtest-4645", Context.NONE);
    }
}

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

Sample Response

Status code:: 200

{
  "value": [
    {
      "properties": {
        "managedInstanceName": "sqlcrudtest-4645",
        "operation": "UpsertManagedServer",
        "operationFriendlyName": "UPDATE MANAGED SERVER",
        "percentComplete": 100,
        "startTime": "2019-12-06T11:08:44.49Z",
        "state": "Cancelled",
        "isCancellable": false
      },
      "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"
    },
    {
      "properties": {
        "managedInstanceName": "sqlcrudtest-4645",
        "operation": "UpsertManagedServer",
        "operationFriendlyName": "UPDATE MANAGED SERVER",
        "percentComplete": 50,
        "startTime": "2019-12-06T11:08:44.49Z",
        "state": "InProgress",
        "isCancellable": true,
        "operationParameters": {
          "currentParameters": {
            "family": "Gen4",
            "tier": "GeneralPurpose",
            "vCores": 8,
            "storageSizeInGB": 32
          },
          "requestedParameters": {
            "family": "Gen4",
            "tier": "BusinessCritical",
            "vCores": 8,
            "storageSizeInGB": 128
          }
        },
        "operationSteps": {
          "totalSteps": "3",
          "currentStep": 3,
          "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:22:47.35Z",
              "stepStartTime": "2019-12-06T11:08:46.15Z",
              "timeElapsed": "14"
            },
            {
              "order": 3,
              "name": "New SQL Instance Startup",
              "status": "InProgress",
              "stepEndTime": "2019-12-06T11:24:50.51Z",
              "stepStartTime": "2019-12-06T11:22:47.42Z",
              "timeElapsed": "2"
            }
          ]
        }
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations/22222222-2222-2222-2222-222222222222",
      "name": "22222222-2222-2222-2222-222222222222",
      "type": "Microsoft.Sql/managedInstances/operations"
    },
    {
      "properties": {
        "managedInstanceName": "sqlcrudtest-4645",
        "operation": "UpsertManagedServer",
        "operationFriendlyName": "UPDATE MANAGED SERVER",
        "percentComplete": 100,
        "startTime": "2019-12-06T14:48:34.583Z",
        "state": "Failed",
        "errorCode": 45157,
        "errorDescription": "Server 'sqlcrudtest-4645' is busy with another operation. Please try your operation later.",
        "errorSeverity": 16,
        "isUserError": true,
        "isCancellable": false
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations/33333333-3333-3333-3333-333333333333",
      "name": "33333333-3333-3333-3333-333333333333",
      "type": "Microsoft.Sql/managedInstances/operations"
    },
    {
      "properties": {
        "managedInstanceName": "sqlcrudtest-4645",
        "operation": "MakeAllManagedDatabasesAccessible",
        "operationFriendlyName": "MAKE ALL MANAGED DBS ACCESSIBLE",
        "percentComplete": 100,
        "startTime": "2019-12-04T09:00:08.1Z",
        "state": "Failed",
        "operationSteps": {
          "totalSteps": "1",
          "currentStep": 1,
          "stepsList": [
            {
              "order": 1,
              "name": "Request validation",
              "status": "Failed",
              "stepEndTime": "2019-12-04T09:01:00.57Z",
              "stepStartTime": "2019-12-04T09:00:30.15Z",
              "timeElapsed": "0"
            }
          ]
        }
      },
      "id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/sqlcrudtest-7398/providers/Microsoft.Sql/managedInstances/sqlcrudtest-4645/operations/44444444-4444-4444-4444-444444444444",
      "name": "44444444-4444-4444-4444-444444444444",
      "type": "Microsoft.Sql/managedInstances/operations"
    }
  ]
}

定义

名称	说明
ManagedInstanceOperation	托管实例操作。
ManagedInstanceOperationListResult	对列表托管实例操作请求的响应
ManagedInstanceOperationParametersPair	托管实例操作的参数。
ManagedInstanceOperationSteps	托管实例操作的步骤。
ManagementOperationState	操作状态。
status
UpsertManagedServerOperationParameters
UpsertManagedServerOperationStepWithEstimatesAndDuration

ManagedInstanceOperation

托管实例操作。

名称	类型	说明
id	string	资源 ID。
name	string	资源名称。
properties.description	string	操作说明。
properties.errorCode	integer	操作错误代码。
properties.errorDescription	string	操作错误说明。
properties.errorSeverity	integer	操作错误严重性。
properties.estimatedCompletionTime	string	操作的估计完成时间。
properties.isCancellable	boolean	是否可以取消操作。
properties.isUserError	boolean	错误是否为用户错误。
properties.managedInstanceName	string	正在其上执行操作的托管实例的名称。
properties.operation	string	操作的名称。
properties.operationFriendlyName	string	操作的友好名称。
properties.operationParameters	ManagedInstanceOperationParametersPair	操作参数。
properties.operationSteps	ManagedInstanceOperationSteps	操作步骤。
properties.percentComplete	integer	操作已完成的百分比。
properties.startTime	string	操作开始时间。
properties.state	ManagementOperationState	操作状态。
type	string	资源类型。

ManagedInstanceOperationListResult

对列表托管实例操作请求的响应

名称	类型	说明
nextLink	string	用于检索下一页结果的链接。
value	ManagedInstanceOperation[]	结果数组。

ManagedInstanceOperationParametersPair

托管实例操作的参数。

名称	类型	说明
currentParameters	UpsertManagedServerOperationParameters	当前参数。
requestedParameters	UpsertManagedServerOperationParameters	请求的参数。

ManagedInstanceOperationSteps

托管实例操作的步骤。

名称	类型	说明
currentStep	integer	当前操作步骤的数目。
stepsList	UpsertManagedServerOperationStepWithEstimatesAndDuration[]	操作步骤列表。
totalSteps	string	操作步骤总数。

ManagementOperationState

操作状态。

名称	类型	说明
CancelInProgress	string
Cancelled	string
Failed	string
InProgress	string
Pending	string
Succeeded	string

status

名称	类型	说明
Canceled	string
Completed	string
Failed	string
InProgress	string
NotStarted	string
SlowedDown	string

UpsertManagedServerOperationParameters

名称	类型	说明
family	string
storageSizeInGB	integer
tier	string
vCores	integer

UpsertManagedServerOperationStepWithEstimatesAndDuration

名称	类型	说明
name	string
order	integer
status	status
stepEndTime	string
stepStartTime	string
timeElapsed	string

Managed Instance Operations - List By Managed Instance

URI 参数

响应

示例

List the managed instance management operations

Sample Request

Sample Response

定义

ManagedInstanceOperation

ManagedInstanceOperationListResult

ManagedInstanceOperationParametersPair

ManagedInstanceOperationSteps

ManagementOperationState

status

UpsertManagedServerOperationParameters

UpsertManagedServerOperationStepWithEstimatesAndDuration

其他资源