Skip to main content

jobs

Creates, updates, deletes, gets or lists a jobs resource.

Overview

Namejobs
TypeResource
Idazure.storage_import_export.jobs

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringSpecifies the resource identifier of the job.
namestringSpecifies the name of the job.
identityobjectSpecifies the job identity details
locationstringSpecifies the Azure location where the job is created.
propertiesobjectSpecifies the job properties
systemDataobjectSystemData of ImportExport Jobs.
tagsobjectSpecifies the tags that are assigned to the job.
typestringSpecifies the type of the job resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectjobName, subscriptionId, resourceGroupNameapi-version, Accept-LanguageGets information about an existing job.
list_by_resource_groupselectsubscriptionId, resourceGroupName$top, $filter, api-version, Accept-LanguageReturns all active and completed jobs in a resource group.
list_by_subscriptionselectsubscriptionId$top, $filter, api-version, Accept-LanguageReturns all active and completed jobs in a subscription.
createinsertjobName, subscriptionId, resourceGroupNameapi-version, Accept-Language, x-ms-client-tenant-idCreates a new job or updates an existing job in the specified subscription.
updateupdatejobName, subscriptionId, resourceGroupNameapi-version, Accept-LanguageUpdates specific properties of a job. You can call this operation to notify the Import/Export service that the hard drives comprising the import or export job have been shipped to the Microsoft data center. It can also be used to cancel an existing job.
deletedeletejobName, subscriptionId, resourceGroupNameapi-version, Accept-LanguageDeletes an existing job. Only jobs in the Creating or Completed states can be deleted.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
jobNamestringThe name of the import/export job.
resourceGroupNamestringThe resource group name uniquely identifies the resource group within the user subscription.
subscriptionIdstringThe subscription ID for the Azure user.
$filterstringCan be used to restrict the results to certain conditions.
$topinteger (int64)An integer value that specifies how many jobs at most should be returned. The value cannot exceed 100.
Accept-LanguagestringSpecifies the preferred language for the response.
api-versionstringSpecifies the API version to use for this request.
x-ms-client-tenant-idstringThe tenant ID of the client making the request.

SELECT examples

Gets information about an existing job.

SELECT
id,
name,
identity,
location,
properties,
systemData,
tags,
type
FROM azure.storage_import_export.jobs
WHERE jobName = '{{ jobName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND api-version = '{{ api-version }}'
AND Accept-Language = '{{ Accept-Language }}'
;

INSERT examples

Creates a new job or updates an existing job in the specified subscription.

INSERT INTO azure.storage_import_export.jobs (
data__location,
data__tags,
data__properties,
jobName,
subscriptionId,
resourceGroupName,
api-version,
Accept-Language,
x-ms-client-tenant-id
)
SELECT
'{{ location }}',
'{{ tags }}',
'{{ properties }}',
'{{ jobName }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ api-version }}',
'{{ Accept-Language }}',
'{{ x-ms-client-tenant-id }}'
RETURNING
id,
name,
identity,
location,
properties,
systemData,
tags,
type
;

UPDATE examples

Updates specific properties of a job. You can call this operation to notify the Import/Export service that the hard drives comprising the import or export job have been shipped to the Microsoft data center. It can also be used to cancel an existing job.

UPDATE azure.storage_import_export.jobs
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
jobName = '{{ jobName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND api-version = '{{ api-version}}'
AND Accept-Language = '{{ Accept-Language}}'
RETURNING
id,
name,
identity,
location,
properties,
systemData,
tags,
type;

DELETE examples

Deletes an existing job. Only jobs in the Creating or Completed states can be deleted.

DELETE FROM azure.storage_import_export.jobs
WHERE jobName = '{{ jobName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND api-version = '{{ api-version }}'
AND Accept-Language = '{{ Accept-Language }}'
;