job_credentials

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

Overview

Name	job_credentials
Type	Resource
Id	azure.sql.job_credentials

Fields

vw_job_credentials

Name	Datatype	Description
credentialName	text	field from the properties object
jobAgentName	text	field from the properties object
password	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
subscriptionId	text	field from the properties object
username	text	field from the properties object

job_credentials

Name	Datatype	Description
properties	object	Properties of a job credential.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	credentialName, jobAgentName, resourceGroupName, serverName, subscriptionId	Gets a jobs credential.
list_by_agent	SELECT	jobAgentName, resourceGroupName, serverName, subscriptionId	Gets a list of jobs credentials.
create_or_update	INSERT	credentialName, jobAgentName, resourceGroupName, serverName, subscriptionId	Creates or updates a job credential.
delete	DELETE	credentialName, jobAgentName, resourceGroupName, serverName, subscriptionId	Deletes a job credential.

SELECT examples

Gets a list of jobs credentials.

vw_job_credentials

SELECT
credentialName,
jobAgentName,
password,
resourceGroupName,
serverName,
subscriptionId,
username
FROM azure.sql.vw_job_credentials
WHERE jobAgentName = '{{ jobAgentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

job_credentials

SELECT
properties
FROM azure.sql.job_credentials
WHERE jobAgentName = '{{ jobAgentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.sql.job_credentials (
credentialName,
jobAgentName,
resourceGroupName,
serverName,
subscriptionId,
properties
)
SELECT 
'{{ credentialName }}',
'{{ jobAgentName }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: username
          value: string
        - name: password
          value: string

DELETE example

Deletes the specified job_credentials resource.

/*+ delete */
DELETE FROM azure.sql.job_credentials
WHERE credentialName = '{{ credentialName }}'
AND jobAgentName = '{{ jobAgentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';