jobs

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

Overview

Name	jobs
Type	Resource
Id	azure.automation.jobs

Fields

vw_jobs

Name	Datatype	Description
automationAccountName	text	field from the properties object
creation_time	text	field from the properties object
end_time	text	field from the properties object
exception	text	field from the properties object
jobName	text	field from the properties object
job_id	text	field from the properties object
last_modified_time	text	field from the properties object
last_status_modified_time	text	field from the properties object
parameters	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
run_on	text	field from the properties object
runbook	text	field from the properties object
start_time	text	field from the properties object
started_by	text	field from the properties object
status	text	field from the properties object
status_details	text	field from the properties object
subscriptionId	text	field from the properties object

jobs

Name	Datatype	Description
properties	object	Definition of job properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	automationAccountName, jobName, resourceGroupName, subscriptionId	Retrieve the job identified by job name.
list_by_automation_account	SELECT	automationAccountName, resourceGroupName, subscriptionId	Retrieve a list of jobs.
create	INSERT	automationAccountName, jobName, resourceGroupName, subscriptionId, data__properties	Create a job of the runbook.
resume	EXEC	automationAccountName, jobName, resourceGroupName, subscriptionId	Resume the job identified by jobName.
stop	EXEC	automationAccountName, jobName, resourceGroupName, subscriptionId	Stop the job identified by jobName.
suspend	EXEC	automationAccountName, jobName, resourceGroupName, subscriptionId	Suspend the job identified by job name.

SELECT examples

Retrieve a list of jobs.

vw_jobs

SELECT
automationAccountName,
creation_time,
end_time,
exception,
jobName,
job_id,
last_modified_time,
last_status_modified_time,
parameters,
provisioning_state,
resourceGroupName,
run_on,
runbook,
start_time,
started_by,
status,
status_details,
subscriptionId
FROM azure.automation.vw_jobs
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

jobs

SELECT
properties
FROM azure.automation.jobs
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
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.automation.jobs (
automationAccountName,
jobName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ automationAccountName }}',
'{{ jobName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: runbook
          value:
            - name: name
              value: string
        - name: parameters
          value: object
        - name: runOn
          value: string