Skip to main content

executions

Creates, updates, deletes, gets or lists an executions resource.

Overview

Nameexecutions
TypeResource
Idazure.workload_orchestration.executions

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
namestringThe name of the resource.
eTagstringIf eTag is provided in the response body, it may also be provided as a header per the normal etag convention. Entity tags are used for comparing two or more entities from the same requested resource. HTTP/1.1 uses entity tags in the etag (section 14.19), If-Match (section 14.24), If-None-Match (section 14.26), and If-Range (section 14.27) header fields.
extendedLocationobject:vartype extended_location: ~azure.mgmt.workloadorchestration.models.ExtendedLocation
provisioningStatestringProvisioning state of resource. Known values are: "Succeeded", "Failed", "Canceled", "Initialized", "InProgress", and "Deleting". (Succeeded, Failed, Canceled, Initialized, InProgress, Deleting)
specificationobjectExecution specification.
statusobjectStatus of Execution.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".
workflowVersionIdstringWorkflow version of execution. Required.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, context_name, workflow_name, version_name, execution_name, subscription_idGet Execution Resource.
list_by_workflow_versionselectresource_group_name, context_name, workflow_name, version_name, subscription_idList Execution Resources.
create_or_updateinsertresource_group_name, context_name, workflow_name, version_name, execution_name, subscription_idCreate or update Execution Resource.
updateupdateresource_group_name, context_name, workflow_name, version_name, execution_name, subscription_idupdate an Execution Resource.
create_or_updatereplaceresource_group_name, context_name, workflow_name, version_name, execution_name, subscription_idCreate or update Execution Resource.
deletedeleteresource_group_name, context_name, workflow_name, version_name, execution_name, subscription_idDelete Execution Resource.

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
context_namestringThe name of the Context. Required.
execution_namestringThe name of the Execution. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
version_namestringThe name of the workflowVersion. Required.
workflow_namestringName of the workflow. Required.

SELECT examples

Get Execution Resource.

SELECT
id,
name,
eTag,
extendedLocation,
provisioningState,
specification,
status,
systemData,
type,
workflowVersionId
FROM azure.workload_orchestration.executions
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND context_name = '{{ context_name }}' -- required
AND workflow_name = '{{ workflow_name }}' -- required
AND version_name = '{{ version_name }}' -- required
AND execution_name = '{{ execution_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or update Execution Resource.

INSERT INTO azure.workload_orchestration.executions (
properties,
extendedLocation,
resource_group_name,
context_name,
workflow_name,
version_name,
execution_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ extendedLocation }}',
'{{ resource_group_name }}',
'{{ context_name }}',
'{{ workflow_name }}',
'{{ version_name }}',
'{{ execution_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
eTag,
extendedLocation,
properties,
systemData,
type
;

UPDATE examples

update an Execution Resource.

UPDATE azure.workload_orchestration.executions
SET
properties = '{{ properties }}',
extendedLocation = '{{ extendedLocation }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND context_name = '{{ context_name }}' --required
AND workflow_name = '{{ workflow_name }}' --required
AND version_name = '{{ version_name }}' --required
AND execution_name = '{{ execution_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
eTag,
extendedLocation,
properties,
systemData,
type;

REPLACE examples

Create or update Execution Resource.

REPLACE azure.workload_orchestration.executions
SET
properties = '{{ properties }}',
extendedLocation = '{{ extendedLocation }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND context_name = '{{ context_name }}' --required
AND workflow_name = '{{ workflow_name }}' --required
AND version_name = '{{ version_name }}' --required
AND execution_name = '{{ execution_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
eTag,
extendedLocation,
properties,
systemData,
type;

DELETE examples

Delete Execution Resource.

DELETE FROM azure.workload_orchestration.executions
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND context_name = '{{ context_name }}' --required
AND workflow_name = '{{ workflow_name }}' --required
AND version_name = '{{ version_name }}' --required
AND execution_name = '{{ execution_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;