job_runs

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

Overview

Name	job_runs
Type	Resource
Id	azure.storage_mover.job_runs

Fields

vw_job_runs

Name	Datatype	Description
agent_name	text	field from the properties object
agent_resource_id	text	field from the properties object
bytes_excluded	text	field from the properties object
bytes_failed	text	field from the properties object
bytes_no_transfer_needed	text	field from the properties object
bytes_scanned	text	field from the properties object
bytes_transferred	text	field from the properties object
bytes_unsupported	text	field from the properties object
error	text	field from the properties object
execution_end_time	text	field from the properties object
execution_start_time	text	field from the properties object
items_excluded	text	field from the properties object
items_failed	text	field from the properties object
items_no_transfer_needed	text	field from the properties object
items_scanned	text	field from the properties object
items_transferred	text	field from the properties object
items_unsupported	text	field from the properties object
jobDefinitionName	text	field from the properties object
jobRunName	text	field from the properties object
job_definition_properties	text	field from the properties object
last_status_update	text	field from the properties object
projectName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
scan_status	text	field from the properties object
source_name	text	field from the properties object
source_properties	text	field from the properties object
source_resource_id	text	field from the properties object
status	text	field from the properties object
storageMoverName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
target_name	text	field from the properties object
target_properties	text	field from the properties object
target_resource_id	text	field from the properties object

job_runs

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	jobDefinitionName, jobRunName, projectName, resourceGroupName, storageMoverName, subscriptionId	Gets a Job Run resource.
list	SELECT	jobDefinitionName, projectName, resourceGroupName, storageMoverName, subscriptionId	Lists all Job Runs in a Job Definition.

SELECT examples

Lists all Job Runs in a Job Definition.

vw_job_runs

SELECT
agent_name,
agent_resource_id,
bytes_excluded,
bytes_failed,
bytes_no_transfer_needed,
bytes_scanned,
bytes_transferred,
bytes_unsupported,
error,
execution_end_time,
execution_start_time,
items_excluded,
items_failed,
items_no_transfer_needed,
items_scanned,
items_transferred,
items_unsupported,
jobDefinitionName,
jobRunName,
job_definition_properties,
last_status_update,
projectName,
provisioning_state,
resourceGroupName,
scan_status,
source_name,
source_properties,
source_resource_id,
status,
storageMoverName,
subscriptionId,
system_data,
target_name,
target_properties,
target_resource_id
FROM azure.storage_mover.vw_job_runs
WHERE jobDefinitionName = '{{ jobDefinitionName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND storageMoverName = '{{ storageMoverName }}'
AND subscriptionId = '{{ subscriptionId }}';

job_runs

SELECT
properties,
systemData
FROM azure.storage_mover.job_runs
WHERE jobDefinitionName = '{{ jobDefinitionName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND storageMoverName = '{{ storageMoverName }}'
AND subscriptionId = '{{ subscriptionId }}';