global_schedules

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

Overview

Name	global_schedules
Type	Resource
Id	azure.dev_test_labs.global_schedules

Fields

vw_global_schedules

Name	Datatype	Description
id	text	The identifier of the resource.
name	text	The name of the resource.
created_date	text	field from the properties object
daily_recurrence	text	field from the properties object
hourly_recurrence	text	field from the properties object
location	text	The location of the resource.
notification_settings	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	The tags of the resource.
target_resource_id	text	field from the properties object
task_type	text	field from the properties object
time_zone_id	text	field from the properties object
type	text	The type of the resource.
unique_identifier	text	field from the properties object
weekly_recurrence	text	field from the properties object

global_schedules

Name	Datatype	Description
id	string	The identifier of the resource.
name	string	The name of the resource.
location	string	The location of the resource.
properties	object	Properties of a schedule.
tags	object	The tags of the resource.
type	string	The type of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	name, resourceGroupName, subscriptionId	Get schedule.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List schedules in a resource group.
list_by_subscription	SELECT	subscriptionId	List schedules in a subscription.
create_or_update	INSERT	name, resourceGroupName, subscriptionId, data__properties	Create or replace an existing schedule.
delete	DELETE	name, resourceGroupName, subscriptionId	Delete schedule.
update	UPDATE	name, resourceGroupName, subscriptionId	Allows modifying tags of schedules. All other properties will be ignored.
execute	EXEC	name, resourceGroupName, subscriptionId	Execute a schedule. This operation can take a while to complete.
retarget	EXEC	name, resourceGroupName, subscriptionId	Updates a schedule's target resource Id. This operation can take a while to complete.

SELECT examples

List schedules in a subscription.

vw_global_schedules

SELECT
id,
name,
created_date,
daily_recurrence,
hourly_recurrence,
location,
notification_settings,
provisioning_state,
resourceGroupName,
status,
subscriptionId,
tags,
target_resource_id,
task_type,
time_zone_id,
type,
unique_identifier,
weekly_recurrence
FROM azure.dev_test_labs.vw_global_schedules
WHERE subscriptionId = '{{ subscriptionId }}';

global_schedules

SELECT
id,
name,
location,
properties,
tags,
type
FROM azure.dev_test_labs.global_schedules
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.dev_test_labs.global_schedules (
name,
resourceGroupName,
subscriptionId,
data__properties,
location,
tags,
properties
)
SELECT 
'{{ name }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: properties
      value:
        - name: status
          value: string
        - name: taskType
          value: string
        - name: weeklyRecurrence
          value:
            - name: weekdays
              value:
                - string
            - name: time
              value: string
        - name: dailyRecurrence
          value:
            - name: time
              value: string
        - name: hourlyRecurrence
          value:
            - name: minute
              value: integer
        - name: timeZoneId
          value: string
        - name: notificationSettings
          value:
            - name: status
              value: string
            - name: timeInMinutes
              value: integer
            - name: webhookUrl
              value: string
            - name: emailRecipient
              value: string
            - name: notificationLocale
              value: string
        - name: createdDate
          value: string
        - name: targetResourceId
          value: string
        - name: provisioningState
          value: string
        - name: uniqueIdentifier
          value: string

UPDATE example

Updates a global_schedules resource.

/*+ update */
UPDATE azure.dev_test_labs.global_schedules
SET 
tags = '{{ tags }}'
WHERE 
name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified global_schedules resource.

/*+ delete */
DELETE FROM azure.dev_test_labs.global_schedules
WHERE name = '{{ name }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';