Skip to main content

jobs

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

Overview

Namejobs
TypeResource
Idazure.media_services.jobs

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
propertiesobjectThe resource properties.
systemDataobjectThe system metadata relating to this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, accountName, transformName, jobNameapi-versionGets a Job.
listselectsubscriptionId, resourceGroupName, accountName, transformNameapi-version, $filter, $orderbyLists all of the Jobs for the Transform.
createinsertsubscriptionId, resourceGroupName, accountName, transformName, jobNameapi-versionCreates a Job.
updateupdatesubscriptionId, resourceGroupName, accountName, transformName, jobNameapi-versionUpdate is only supported for description and priority. Updating Priority will take effect when the Job state is Queued or Scheduled and depending on the timing the priority update may be ignored.
deletedeletesubscriptionId, resourceGroupName, accountName, transformName, jobNameapi-versionDeletes a Job.
cancel_jobexecsubscriptionId, resourceGroupName, accountName, transformName, jobNameapi-versionCancel a Job.

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
accountNamestringThe Media Services account name.
jobNamestringThe Job name.
resourceGroupNamestringThe name of the resource group within the Azure subscription.
subscriptionIdstringThe unique identifier for a Microsoft Azure subscription.
transformNamestringThe Transform name.
$filterstringRestricts the set of items returned.
$orderbystringSpecifies the key by which the result collection should be ordered.
api-versionstringThe version of the API to be used with the client request.

SELECT examples

Gets a Job.

SELECT
properties,
systemData
FROM azure.media_services.jobs
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND accountName = '{{ accountName }}' -- required
AND transformName = '{{ transformName }}' -- required
AND jobName = '{{ jobName }}' -- required
AND api-version = '{{ api-version }}'
;

INSERT examples

Creates a Job.

INSERT INTO azure.media_services.jobs (
data__properties,
subscriptionId,
resourceGroupName,
accountName,
transformName,
jobName,
api-version
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ accountName }}',
'{{ transformName }}',
'{{ jobName }}',
'{{ api-version }}'
RETURNING
properties,
systemData
;

UPDATE examples

Update is only supported for description and priority. Updating Priority will take effect when the Job state is Queued or Scheduled and depending on the timing the priority update may be ignored.

UPDATE azure.media_services.jobs
SET
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND transformName = '{{ transformName }}' --required
AND jobName = '{{ jobName }}' --required
AND api-version = '{{ api-version}}'
RETURNING
properties,
systemData;

DELETE examples

Deletes a Job.

DELETE FROM azure.media_services.jobs
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND accountName = '{{ accountName }}' --required
AND transformName = '{{ transformName }}' --required
AND jobName = '{{ jobName }}' --required
AND api-version = '{{ api-version }}'
;

Lifecycle Methods

Cancel a Job.

EXEC azure.media_services.jobs.cancel_job 
@subscriptionId='{{ subscriptionId }}' --required,
@resourceGroupName='{{ resourceGroupName }}' --required,
@accountName='{{ accountName }}' --required,
@transformName='{{ transformName }}' --required,
@jobName='{{ jobName }}' --required,
@api-version='{{ api-version }}'
;