Sql Server Instances - get Jobs Status

Service:

Arc Data

API Version:

2026-01-01

Gets jobs status details for sql arc resource

POST https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.AzureArcData/sqlServerInstances/{sqlServerInstanceName}/getJobsStatus?api-version=2026-01-01

URI Parameters

Name	In	Required	Type	Description
resourceGroupName	path	True	string	The name of the Azure resource group
sqlServerInstanceName	path	True	string	Name of SQL Server Instance
subscriptionId	path	True	string	The ID of the Azure subscription
api-version	query	True	string	The API version to use for the request

Request Body

Name	Type	Description
SqlServerInstanceJobsStatusRequest	SqlServerInstanceJobsStatusRequest	Contains the parameters to get SQL Server instance agent jobs status.

Responses

Name	Type	Description
200 OK	SqlServerInstanceJobsStatusResponse	OK
Other Status Codes	ErrorResponse	*** Error Responses: ***

Examples

Retrieves Arc SQL Server instance jobs status

Sample request

HTTP

POST https://management.azure.com/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/testrg/providers/Microsoft.AzureArcData/sqlServerInstances/testsqlserver/getJobsStatus?api-version=2026-01-01

{
  "featureName": "MigrationAssessment",
  "jobType": "Ondemand"
}

Sample response

Status code:

200

{
  "jobsStatus": [
    {
      "id": "/subscriptions/a5082b19-8a6e-4bc5-8fdd-8ef39dfebc39/resourceGroups/alzahedi-rg-easyup/providers/Microsoft.AzureArcData/sqlServerInstances/arcee-dev/jobs/235e045f:2D5237:2D38eb:2Db8fa:2Df0f549d1d7d9MigrationJobOnDemand",
      "instanceName": "MSSQLSERVER",
      "jobStatus": "Failed",
      "jobException": "Something went wrong in collection suitability",
      "backgroundJob": {
        "state": "Completed",
        "executionState": "Waiting",
        "startTime": "2024-02-22T00:04:06.88265-08:00",
        "endTime": "2024-03-15T02:04:06.88265-07:00",
        "lastExecutionTime": "2024-02-22T21:18:21.6083558-08:00",
        "lastExecutionStatus": "Succeeded"
      },
      "sequencerActions": [
        {
          "actionId": ":2Fsubscriptions:2Fa5082b19:2D8a6e:2D4bc5:2D8fdd:2D8ef39dfebc39:2FresourceGroups:2Falzahedi:2Drg:2Deasyup:2Fproviders:2FMicrosoft:2EAzureArcData:2FsqlServerInstances:2Farcee:2Ddev:2Faction:2FMicrosoft:2ESqlServer:2EManagement:2EMigrationAssessmentPlugin:2EActions:2ERunOnDemandMigrationJob",
          "state": "Completed",
          "result": "Failed"
        },
        {
          "actionId": "system.last",
          "state": "Completed",
          "result": "Succeeded"
        },
        {
          "actionId": "system.first",
          "state": "Completed",
          "result": "Succeeded"
        }
      ]
    }
  ]
}

Definitions

Name	Description
BackgroundJob	The background job details.
ErrorAdditionalInfo	The resource management error additional info.
ErrorDetail	The error detail.
ErrorResponse	Error response
executionState	The execution state of the background job.
jobStatus	The status of the job.
lastExecutionStatus	The last execution status of the background job.
result	The result of the sequencer action.
SequencerAction	The list of sequencer actions.
sequencerState	The state of the sequencer action.
SqlServerInstanceJobsStatusRequest	Contains the parameters to get SQL Server instance agent jobs status.
SqlServerInstanceJobsStatusResponse	The response for the status of the jobs running on the SQL Server instance.
SqlServerInstanceJobStatus	The list of jobs status running on the SQL Server instance.
state	The state of the background job.

BackgroundJob

Object

The background job details.

Name	Type	Description
endTime	string (date-time)	The end time of the background job.
executionState	executionState	The execution state of the background job.
lastExecutionStatus	lastExecutionStatus	The last execution status of the background job.
lastExecutionTime	string (date-time)	The last execution time of the background job.
startTime	string (date-time)	The start time of the background job.
state	state	The state of the background job.

ErrorAdditionalInfo

Object

The resource management error additional info.

Name	Type	Description
info	object	The additional info.
type	string	The additional info type.

ErrorDetail

Object

The error detail.

Name	Type	Description
additionalInfo	ErrorAdditionalInfo[]	The error additional info.
code	string	The error code.
details	ErrorDetail[]	The error details.
message	string	The error message.
target	string	The error target.

ErrorResponse

Object

Error response

Name	Type	Description
error	ErrorDetail	The error object.

executionState

Enumeration

The execution state of the background job.

Value	Description
Waiting
Running

jobStatus

Enumeration

The status of the job.

Value	Description
NotStarted
InProgress
Succeeded
Failed

lastExecutionStatus

Enumeration

The last execution status of the background job.

Value	Description
Succeeded
Completed
Failed
Faulted
Postponed
Rescheduled

result

Enumeration

The result of the sequencer action.

Value	Description
NotCompleted
Succeeded
Failed
TimedOut
Skipped

SequencerAction

Object

The list of sequencer actions.

Name	Type	Description
actionId	string	The unique identifier of the sequencer action.
result	result	The result of the sequencer action.
state	sequencerState	The state of the sequencer action.

sequencerState

Enumeration

The state of the sequencer action.

Value	Description
NotStarted
WaitingPredecessors
ExecutingAction
CreatingSuccessors
Completed

SqlServerInstanceJobsStatusRequest

Object

Contains the parameters to get SQL Server instance agent jobs status.

Name	Type	Description
featureName	string	The name of the feature to retrieve the job status for.
jobType	string	The type of the job to retrieve the status for.

SqlServerInstanceJobsStatusResponse

Object

The response for the status of the jobs running on the SQL Server instance.

Name	Type	Description
jobsStatus	SqlServerInstanceJobStatus[]	The list of jobs status running on the SQL Server instance.

SqlServerInstanceJobStatus

Object

The list of jobs status running on the SQL Server instance.

Name	Type	Description
backgroundJob	BackgroundJob	The background job details.
id	string	The unique identifier of the job.
instanceName	string	The name of the SQL Server instance.
jobException	string	The exception message if the job failed.
jobStatus	jobStatus	The status of the job.
sequencerActions	SequencerAction[]	The list of sequencer actions.

state

Enumeration

The state of the background job.

Value	Description
Enabled
Disabled
Deleted
Completed
Faulted
Suspended