job_private_endpoints

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

Overview

Name	job_private_endpoints
Type	Resource
Id	azure.sql.job_private_endpoints

Fields

vw_job_private_endpoints

Name	Datatype	Description
jobAgentName	text	field from the properties object
privateEndpointName	text	field from the properties object
private_endpoint_id	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
target_server_azure_resource_id	text	field from the properties object

job_private_endpoints

Name	Datatype	Description
properties	object	Properties of job agent private endpoint.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	jobAgentName, privateEndpointName, resourceGroupName, serverName, subscriptionId	Gets a private endpoint.
list_by_agent	SELECT	jobAgentName, resourceGroupName, serverName, subscriptionId	Gets a list of job agent private endpoints.
create_or_update	INSERT	jobAgentName, privateEndpointName, resourceGroupName, serverName, subscriptionId	Creates or updates a private endpoint.
delete	DELETE	jobAgentName, privateEndpointName, resourceGroupName, serverName, subscriptionId	Deletes a private endpoint.

SELECT examples

Gets a list of job agent private endpoints.

vw_job_private_endpoints

SELECT
jobAgentName,
privateEndpointName,
private_endpoint_id,
resourceGroupName,
serverName,
subscriptionId,
target_server_azure_resource_id
FROM azure.sql.vw_job_private_endpoints
WHERE jobAgentName = '{{ jobAgentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

job_private_endpoints

SELECT
properties
FROM azure.sql.job_private_endpoints
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_private_endpoints resource.

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: targetServerAzureResourceId
          value: string
        - name: privateEndpointId
          value: string

DELETE example

Deletes the specified job_private_endpoints resource.

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