job_collections

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

Overview

Name	job_collections
Type	Resource
Id	azure.scheduler.job_collections

Fields

vw_job_collections

Name	Datatype	Description
id	text	Gets the job collection resource identifier.
name	text	Gets or sets the job collection resource name.
jobCollectionName	text	field from the properties object
location	text	Gets or sets the storage account location.
quota	text	field from the properties object
resourceGroupName	text	field from the properties object
sku	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Gets or sets the tags.
type	text	Gets the job collection resource type.

job_collections

Name	Datatype	Description
id	string	Gets the job collection resource identifier.
name	string	Gets or sets the job collection resource name.
location	string	Gets or sets the storage account location.
properties	object
tags	object	Gets or sets the tags.
type	string	Gets the job collection resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	jobCollectionName, resourceGroupName, subscriptionId	Gets a job collection.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all job collections under specified resource group.
list_by_subscription	SELECT	subscriptionId	Gets all job collections under specified subscription.
create_or_update	INSERT	jobCollectionName, resourceGroupName, subscriptionId	Provisions a new job collection or updates an existing job collection.
delete	DELETE	jobCollectionName, resourceGroupName, subscriptionId	Deletes a job collection.
patch	UPDATE	jobCollectionName, resourceGroupName, subscriptionId	Patches an existing job collection.
disable	EXEC	jobCollectionName, resourceGroupName, subscriptionId	Disables all of the jobs in the job collection.
enable	EXEC	jobCollectionName, resourceGroupName, subscriptionId	Enables all of the jobs in the job collection.

SELECT examples

Gets all job collections under specified subscription.

vw_job_collections

SELECT
id,
name,
jobCollectionName,
location,
quota,
resourceGroupName,
sku,
state,
subscriptionId,
tags,
type
FROM azure.scheduler.vw_job_collections
WHERE subscriptionId = '{{ subscriptionId }}';

job_collections

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

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.scheduler.job_collections (
jobCollectionName,
resourceGroupName,
subscriptionId,
name,
location,
tags,
properties
)
SELECT 
'{{ jobCollectionName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ name }}',
'{{ location }}',
'{{ tags }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: id
      value: string
    - name: type
      value: string
    - name: name
      value: string
    - name: location
      value: string
    - name: tags
      value: object
    - name: properties
      value:
        - name: sku
          value:
            - name: name
              value: string
        - name: state
          value: string
        - name: quota
          value:
            - name: maxJobCount
              value: integer
            - name: maxJobOccurrence
              value: integer
            - name: maxRecurrence
              value:
                - name: frequency
                  value: string
                - name: interval
                  value: integer

UPDATE example

Updates a job_collections resource.

/*+ update */
UPDATE azure.scheduler.job_collections
SET 
name = '{{ name }}',
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
jobCollectionName = '{{ jobCollectionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified job_collections resource.

/*+ delete */
DELETE FROM azure.scheduler.job_collections
WHERE jobCollectionName = '{{ jobCollectionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';