jobs

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

Overview

Name	jobs
Type	Resource
Id	azure.media_services.jobs

Fields

vw_jobs

Name	Datatype	Description
description	text	field from the properties object
accountName	text	field from the properties object
correlation_data	text	field from the properties object
created	text	field from the properties object
end_time	text	field from the properties object
input	text	field from the properties object
jobName	text	field from the properties object
last_modified	text	field from the properties object
outputs	text	field from the properties object
priority	text	field from the properties object
resourceGroupName	text	field from the properties object
start_time	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
transformName	text	field from the properties object

jobs

Name	Datatype	Description
properties	object	Properties of the Job.
systemData	object	Metadata pertaining to creation and last modification of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, jobName, resourceGroupName, subscriptionId, transformName	Gets a Job.
list	SELECT	accountName, resourceGroupName, subscriptionId, transformName	Lists all of the Jobs for the Transform.
create	INSERT	accountName, jobName, resourceGroupName, subscriptionId, transformName	Creates a Job.
delete	DELETE	accountName, jobName, resourceGroupName, subscriptionId, transformName	Deletes a Job.
update	UPDATE	accountName, jobName, resourceGroupName, subscriptionId, transformName	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.
cancel_job	EXEC	accountName, jobName, resourceGroupName, subscriptionId, transformName	Cancel a Job.

SELECT examples

Lists all of the Jobs for the Transform.

vw_jobs

SELECT
description,
accountName,
correlation_data,
created,
end_time,
input,
jobName,
last_modified,
outputs,
priority,
resourceGroupName,
start_time,
state,
subscriptionId,
system_data,
transformName
FROM azure.media_services.vw_jobs
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND transformName = '{{ transformName }}';

jobs

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

INSERT example

Use the following StackQL query and manifest file to create a new jobs resource.

All Properties

/*+ create */
INSERT INTO azure.media_services.jobs (
accountName,
jobName,
resourceGroupName,
subscriptionId,
transformName,
properties
)
SELECT 
'{{ accountName }}',
'{{ jobName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ transformName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: created
          value: string
        - name: state
          value: string
        - name: description
          value: string
        - name: input
          value:
            - name: '@odata.type'
              value: string
        - name: lastModified
          value: string
        - name: outputs
          value:
            - - name: '@odata.type'
                value: string
              - name: error
                value:
                  - name: code
                    value: string
                  - name: message
                    value: string
                  - name: category
                    value: string
                  - name: retry
                    value: string
                  - name: details
                    value:
                      - - name: code
                          value: string
                        - name: message
                          value: string
              - name: presetOverride
                value:
                  - name: '@odata.type'
                    value: string
              - name: state
                value: string
              - name: progress
                value: integer
              - name: label
                value: string
              - name: startTime
                value: string
              - name: endTime
                value: string
        - name: priority
          value: string
        - name: correlationData
          value: object
        - name: startTime
          value: string
        - name: endTime
          value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string

UPDATE example

Updates a jobs resource.

/*+ update */
UPDATE azure.media_services.jobs
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND jobName = '{{ jobName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND transformName = '{{ transformName }}';

DELETE example

Deletes the specified jobs resource.

/*+ delete */
DELETE FROM azure.media_services.jobs
WHERE accountName = '{{ accountName }}'
AND jobName = '{{ jobName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND transformName = '{{ transformName }}';