jobs

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

Overview

Name	jobs
Type	Resource
Id	azure.spring_apps.jobs

Fields

vw_jobs

Name	Datatype	Description
jobName	text	field from the properties object
managed_component_references	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
serviceName	text	field from the properties object
source	text	field from the properties object
subscriptionId	text	field from the properties object
template	text	field from the properties object
trigger_config	text	field from the properties object

jobs

Name	Datatype	Description
properties	object	Job resource properties payload

Methods

Name	Accessible by	Required Params	Description
get	SELECT	jobName, resourceGroupName, serviceName, subscriptionId	Get a Job and its properties.
list	SELECT	resourceGroupName, serviceName, subscriptionId	Get the Azure Spring Apps Jobs in a given service
create_or_update	INSERT	jobName, resourceGroupName, serviceName, subscriptionId	Create a new Job or update an exiting Job.
delete	DELETE	jobName, resourceGroupName, serviceName, subscriptionId	Operation to delete a Job.
start	EXEC	jobName, resourceGroupName, serviceName, subscriptionId

SELECT examples

Get the Azure Spring Apps Jobs in a given service

vw_jobs

SELECT
jobName,
managed_component_references,
provisioning_state,
resourceGroupName,
serviceName,
source,
subscriptionId,
template,
trigger_config
FROM azure.spring_apps.vw_jobs
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

jobs

SELECT
properties
FROM azure.spring_apps.jobs
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.spring_apps.jobs (
jobName,
resourceGroupName,
serviceName,
subscriptionId,
properties
)
SELECT 
'{{ jobName }}',
'{{ resourceGroupName }}',
'{{ serviceName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: template
          value:
            - name: environmentVariables
              value:
                - - name: name
                    value: string
                  - name: value
                    value: string
                  - name: secretValue
                    value: string
            - name: args
              value:
                - string
            - name: resourceRequests
              value:
                - name: cpu
                  value: string
                - name: memory
                  value: string
        - name: source
          value:
            - name: type
              value: string
            - name: version
              value: string
        - name: managedComponentReferences
          value: []
        - name: triggerConfig
          value:
            - name: triggerType
              value: string

DELETE example

Deletes the specified jobs resource.

/*+ delete */
DELETE FROM azure.spring_apps.jobs
WHERE jobName = '{{ jobName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serviceName = '{{ serviceName }}'
AND subscriptionId = '{{ subscriptionId }}';