agents

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

Overview

Name	agents
Type	Resource
Id	azure.sql.agents

Fields

vw_agents

Name	Datatype	Description
managedInstanceName	text	field from the properties object
resourceGroupName	text	field from the properties object
state	text	field from the properties object
subscriptionId	text	field from the properties object

agents

Name	Datatype	Description
properties	object	Sql agent configuration properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	managedInstanceName, resourceGroupName, subscriptionId	Gets current instance sql agent configuration.
create_or_update	INSERT	managedInstanceName, resourceGroupName, subscriptionId	Puts new sql agent configuration to instance.

SELECT examples

Gets current instance sql agent configuration.

vw_agents

SELECT
managedInstanceName,
resourceGroupName,
state,
subscriptionId
FROM azure.sql.vw_agents
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

agents

SELECT
properties
FROM azure.sql.agents
WHERE managedInstanceName = '{{ managedInstanceName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.agents (
managedInstanceName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ managedInstanceName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: state
          value: string