Skip to main content

retention_policies

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

Overview

Nameretention_policies
TypeResource
Idazure.durable_task.retention_policies

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.
provisioningStatestringThe status of the last operation. Known values are: "Succeeded", "Failed", "Canceled", "Provisioning", "Updating", "Deleting", and "Accepted". (Succeeded, Failed, Canceled, Provisioning, Updating, Deleting, Accepted)
retentionPoliciesarrayThe orchestration retention policies.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, scheduler_name, subscription_idGet a Retention Policy.
create_or_replaceinsertresource_group_name, scheduler_name, subscription_idCreate or Update a Retention Policy.
updateupdateresource_group_name, scheduler_name, subscription_idUpdate a Retention Policy.
create_or_replacereplaceresource_group_name, scheduler_name, subscription_idCreate or Update a Retention Policy.
deletedeleteresource_group_name, scheduler_name, subscription_idDelete a Retention Policy.
list_by_schedulerexecresource_group_name, scheduler_name, subscription_idList Retention Policies.

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
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
scheduler_namestringThe name of the Scheduler. Required.
subscription_idstring

SELECT examples

Get a Retention Policy.

SELECT
id,
name,
provisioningState,
retentionPolicies,
systemData,
type
FROM azure.durable_task.retention_policies
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND scheduler_name = '{{ scheduler_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Create or Update a Retention Policy.

INSERT INTO azure.durable_task.retention_policies (
properties,
resource_group_name,
scheduler_name,
subscription_id
)
SELECT
'{{ properties }}',
'{{ resource_group_name }}',
'{{ scheduler_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties,
systemData,
type
;

UPDATE examples

Update a Retention Policy.

UPDATE azure.durable_task.retention_policies
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND scheduler_name = '{{ scheduler_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

REPLACE examples

Create or Update a Retention Policy.

REPLACE azure.durable_task.retention_policies
SET
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND scheduler_name = '{{ scheduler_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Delete a Retention Policy.

DELETE FROM azure.durable_task.retention_policies
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND scheduler_name = '{{ scheduler_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;

Lifecycle Methods

List Retention Policies.

EXEC azure.durable_task.retention_policies.list_by_scheduler 
@resource_group_name='{{ resource_group_name }}' --required,
@scheduler_name='{{ scheduler_name }}' --required,
@subscription_id='{{ subscription_id }}' --required
;