Skip to main content

vw_job_definitions

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

Overview​

Namevw_job_definitions
TypeView
Idazure.storage_mover.vw_job_definitions

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
systemData as system_data,
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.copyMode') as "copy_mode",
JSON_EXTRACT(properties, '$.sourceName') as "source_name",
JSON_EXTRACT(properties, '$.sourceResourceId') as "source_resource_id",
JSON_EXTRACT(properties, '$.sourceSubpath') as "source_subpath",
JSON_EXTRACT(properties, '$.targetName') as "target_name",
JSON_EXTRACT(properties, '$.targetResourceId') as "target_resource_id",
JSON_EXTRACT(properties, '$.targetSubpath') as "target_subpath",
JSON_EXTRACT(properties, '$.latestJobRunName') as "latest_job_run_name",
JSON_EXTRACT(properties, '$.latestJobRunResourceId') as "latest_job_run_resource_id",
JSON_EXTRACT(properties, '$.latestJobRunStatus') as "latest_job_run_status",
JSON_EXTRACT(properties, '$.agentName') as "agent_name",
JSON_EXTRACT(properties, '$.agentResourceId') as "agent_resource_id",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
subscriptionId,
resourceGroupName,
storageMoverName,
projectName,
jobDefinitionName
FROM azure.storage_mover.job_definitions
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND storageMoverName = 'replace-me' AND projectName = 'replace-me';