Managed Instance Operations - List By Managed Instance

Referensi

Service:: SQL Database

API Version:: 2021-02-01-preview

Mendapatkan daftar operasi yang dilakukan pada instans terkelola.

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

Parameter URI

Name	In	Required	Type	Description
managedInstanceName	path	True	string	Nama instans terkelola.
resourceGroupName	path	True	string	Nama grup sumber daya yang berisi sumber daya. Anda dapat memperoleh nilai ini dari Azure Resource Manager API atau portal.
subscriptionId	path	True	string	ID langganan yang mengidentifikasi langganan Azure.
api-version	query	True	string	Versi API yang digunakan untuk permintaan.

Respons

Name	Type	Description
200 OK	ManagedInstanceOperationListResult	Permintaan untuk mendapatkan operasi instans terkelola telah berhasil dijalankan.
Other Status Codes		Respons Kesalahan: *** 404 SubscriptionDoesNotHaveServer - Server yang diminta tidak ditemukan 404 ServerNotInSubscriptionResourceGroup - Server yang ditentukan tidak ada di grup sumber daya dan langganan yang ditentukan.

Name

Type

Description

200 OK

ManagedInstanceOperationListResult

Permintaan untuk mendapatkan operasi instans terkelola telah berhasil dijalankan.

Other Status Codes

Respons Kesalahan: ***

404 SubscriptionDoesNotHaveServer - Server yang diminta tidak ditemukan
404 ServerNotInSubscriptionResourceGroup - Server yang ditentukan tidak ada di grup sumber daya dan langganan yang ditentukan.

Contoh

List the managed instance management operations

Sample Request

HTTP

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

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"
            },
            {
              "order": 2,
              "name": "Virtual Cluster resize/creation",
              "status": "Completed"
            },
            {
              "order": 3,
              "name": "New SQL Instance Startup",
              "status": "InProgress"
            }
          ]
        }
      },
      "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": "2017-06-01T09:00:08.1Z",
        "state": "Succeeded",
        "operationSteps": {
          "totalSteps": "1",
          "currentStep": 1,
          "stepsList": [
            {
              "order": 1,
              "name": "Request validation",
              "status": "Failed"
            }
          ]
        }
      },
      "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"
    }
  ]
}

Definisi

ManagedInstanceOperation	Operasi instans terkelola.
ManagedInstanceOperationListResult	Respons terhadap permintaan operasi instans terkelola daftar
ManagedInstanceOperationParametersPair	Parameter operasi instans terkelola.
ManagedInstanceOperationSteps	Langkah-langkah operasi instans terkelola.
ManagementOperationState	Status operasi.
UpsertManagedServerOperationParameters
UpsertManagedServerOperationStep

ManagedInstanceOperation

Operasi instans terkelola.

Name	Type	Description
id	string	ID Sumber Daya.
name	string	Nama sumber daya.
properties.description	string	Deskripsi operasi.
properties.errorCode	integer	Kode kesalahan operasi.
properties.errorDescription	string	Deskripsi kesalahan operasi.
properties.errorSeverity	integer	Tingkat keparahan kesalahan operasi.
properties.estimatedCompletionTime	string	Perkiraan waktu penyelesaian operasi.
properties.isCancellable	boolean	Apakah operasi dapat dibatalkan.
properties.isUserError	boolean	Apakah kesalahan tersebut adalah kesalahan pengguna atau tidak.
properties.managedInstanceName	string	Nama instans terkelola tempat operasi sedang dilakukan.
properties.operation	string	Nama operasi.
properties.operationFriendlyName	string	Nama operasi yang ramah.
properties.operationParameters	ManagedInstanceOperationParametersPair	Parameter operasi.
properties.operationSteps	ManagedInstanceOperationSteps	Langkah-langkah operasi.
properties.percentComplete	integer	Persentase operasi selesai.
properties.startTime	string	Waktu mulai operasi.
properties.state	ManagementOperationState	Status operasi.
type	string	Jenis sumber daya

ManagedInstanceOperationListResult

Respons terhadap permintaan operasi instans terkelola daftar

Name	Type	Description
nextLink	string	Tautan untuk mengambil halaman hasil berikutnya.
value	ManagedInstanceOperation[]	Array hasil.

ManagedInstanceOperationParametersPair

Parameter operasi instans terkelola.

Name	Type	Description
currentParameters	UpsertManagedServerOperationParameters	Parameter saat ini.
requestedParameters	UpsertManagedServerOperationParameters	Parameter yang diminta.

ManagedInstanceOperationSteps

Langkah-langkah operasi instans terkelola.

Name	Type	Description
currentStep	integer	Jumlah langkah operasi saat ini.
stepsList	UpsertManagedServerOperationStep[]	Daftar langkah-langkah operasi.
totalSteps	string	Jumlah total langkah operasi.

ManagementOperationState

Status operasi.

Name	Type	Description
CancelInProgress	string
Cancelled	string
Failed	string
InProgress	string
Pending	string
Succeeded	string

UpsertManagedServerOperationParameters

Name	Type	Description
family	string
storageSizeInGB	integer
tier	string
vCores	integer

UpsertManagedServerOperationStep

Name	Type	Description
name	string
order	integer
status	enum: Canceled Completed Failed InProgress NotStarted SlowedDown