schedules

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

Overview

Name	schedules
Type	Resource
Id	azure.dev_center.schedules

Fields

vw_schedules

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	text	The name of the resource
frequency	text	field from the properties object
poolName	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
scheduleName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
time	text	field from the properties object
time_zone	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

schedules

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. E.g. "/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}"
name	string	The name of the resource
properties	object	The Schedule properties defining when and what to execute.
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	poolName, projectName, resourceGroupName, scheduleName, subscriptionId	Gets a schedule resource.
list_by_pool	SELECT	poolName, projectName, resourceGroupName, subscriptionId	Lists schedules for a pool
create_or_update	INSERT	poolName, projectName, resourceGroupName, scheduleName, subscriptionId	Creates or updates a Schedule.
delete	DELETE	poolName, projectName, resourceGroupName, scheduleName, subscriptionId	Deletes a Scheduled.
update	UPDATE	poolName, projectName, resourceGroupName, scheduleName, subscriptionId	Partially updates a Scheduled.

SELECT examples

Lists schedules for a pool

vw_schedules

SELECT
id,
name,
frequency,
poolName,
projectName,
provisioning_state,
resourceGroupName,
scheduleName,
state,
subscriptionId,
system_data,
time,
time_zone,
type
FROM azure.dev_center.vw_schedules
WHERE poolName = '{{ poolName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

schedules

SELECT
id,
name,
properties,
systemData,
type
FROM azure.dev_center.schedules
WHERE poolName = '{{ poolName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.dev_center.schedules (
poolName,
projectName,
resourceGroupName,
scheduleName,
subscriptionId,
properties
)
SELECT 
'{{ poolName }}',
'{{ projectName }}',
'{{ resourceGroupName }}',
'{{ scheduleName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: properties
      value:
        - name: type
          value: []
        - name: frequency
          value: []
        - name: time
          value: string
        - name: timeZone
          value: string
        - name: state
          value: []
        - name: provisioningState
          value: []

UPDATE example

Updates a schedules resource.

/*+ update */
UPDATE azure.dev_center.schedules
SET 
properties = '{{ properties }}'
WHERE 
poolName = '{{ poolName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND scheduleName = '{{ scheduleName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified schedules resource.

/*+ delete */
DELETE FROM azure.dev_center.schedules
WHERE poolName = '{{ poolName }}'
AND projectName = '{{ projectName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND scheduleName = '{{ scheduleName }}'
AND subscriptionId = '{{ subscriptionId }}';