job_schedules

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

Overview

Name	job_schedules
Type	Resource
Id	azure.automation.job_schedules

Fields

vw_job_schedules

Name	Datatype	Description
id	text	Gets the id of the resource.
name	text	Gets the name of the variable.
automationAccountName	text	field from the properties object
jobScheduleId	text	field from the properties object
job_schedule_id	text	field from the properties object
parameters	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
schedule	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Resource type

job_schedules

Name	Datatype	Description
id	string	Gets the id of the resource.
name	string	Gets the name of the variable.
properties	object	Definition of job schedule parameters.
type	string	Resource type

Methods

Name	Accessible by	Required Params	Description
get	SELECT	automationAccountName, jobScheduleId, resourceGroupName, subscriptionId	Retrieve the job schedule identified by job schedule name.
list_by_automation_account	SELECT	automationAccountName, resourceGroupName, subscriptionId	Retrieve a list of job schedules.
create	INSERT	automationAccountName, jobScheduleId, resourceGroupName, subscriptionId, data__properties	Create a job schedule.
delete	DELETE	automationAccountName, jobScheduleId, resourceGroupName, subscriptionId	Delete the job schedule identified by job schedule name.

SELECT examples

Retrieve a list of job schedules.

vw_job_schedules

SELECT
id,
name,
automationAccountName,
jobScheduleId,
job_schedule_id,
parameters,
resourceGroupName,
run_on,
runbook,
schedule,
subscriptionId,
type
FROM azure.automation.vw_job_schedules
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

job_schedules

SELECT
id,
name,
properties,
type
FROM azure.automation.job_schedules
WHERE automationAccountName = '{{ automationAccountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.automation.job_schedules (
automationAccountName,
jobScheduleId,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ automationAccountName }}',
'{{ jobScheduleId }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

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

DELETE example

Deletes the specified job_schedules resource.

/*+ delete */
DELETE FROM azure.automation.job_schedules
WHERE automationAccountName = '{{ automationAccountName }}'
AND jobScheduleId = '{{ jobScheduleId }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';