Skip to content

New-AzSqlElasticJobPrivateEndpoint will not complete #27873

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom
Open
lostsole opened this issue May 29, 2025 · 5 comments
Open

New-AzSqlElasticJobPrivateEndpoint will not complete #27873

lostsole opened this issue May 29, 2025 · 5 comments
Labels
bug This issue requires a change to an existing behavior in the product in order to be resolved. customer-reported Service Attention This issue is responsible by Azure service team. SQL - Elastic Jobs

Comments

@lostsole
Copy link

Description

This Module will not complete after adding all parameters. I can see in the portal that the object was created, but will not complete unless I got to the private link and approve then it powershell session will complete
$agent | New-AzSqlElasticJobPrivateEndpoint -Name "pename-i-am-using" -TargetServerAzureResourceId "/subscriptions/xxxxxxxxxx/resourceGroups/xxxxxxx/providers/Microsoft.Sql/servers/sql-xxxxxxxxxxx"

az 14.0.0
there is no debug output,

azapi = {
source = "azure/azapi"
version = "2.4.0"
}
Just as an fyi I am have the same issues with Terraform
resource "azapi_resource" "privateEndpoint1" {
type = "Microsoft.Sql/servers/jobAgents/privateEndpoints@2024-05-01-preview"}

Issue script & Debug output

C:\_Deploy\DBAUtil> $DebugPreference='Continue'

C:\_Deploy\DBAUtil> $agent | New-AzSqlElasticJobPrivateEndpoint -Name pep-xyz-01 -TargetServerAzureResourceId "/subscriptions/xxxxxxxxx/resourceGroups/rg-xxxxxxxxx/providers/Microsoft.Sql/servers/sql-xxxxxxxxx-01" -Verbose
DEBUG: 3:55:31 PM - [ConfigManager] Got nothing from [DisplaySecretsWarning], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: 3:55:31 PM - NewAzureSqlElasticJobPrivateEndpoint begin processing with ParameterSet 'DefaultSet'.
DEBUG: 3:55:31 PM - using account id '[email protected]'...
DEBUG: 3:55:31 PM - [ConfigManager] Got [False] from [DisplayBreakingChangeWarning], Module = [Az.Sql], Cmdlet = [New-AzSqlElasticJobPrivateEndpoint].
DEBUG: 3:55:31 PM - PrivateEndpointName: pep-xyz-01
DEBUG: [Common.Authentication]: Authenticating using Account: '[email protected]', environment: 'AzureCloud', tenant: 'cxxxxxxxx'
DEBUG: 3:55:31 PM - [ConfigManager] Got nothing from [DisableInstanceDiscovery], Module = [], Cmdlet = []. Returning default value [False].
DEBUG: 3:55:31 PM - [ConfigManager] Got [False] from [EnableLoginByWam], Module = [], Cmdlet = [].
VERBOSE: Performing the operation "About to process resource" on target "".
DEBUG: 3:55:31 PM - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'cxxxxxxxxx', Scopes:'https://management.core.windows.net//.default', AuthorityHost:'https://login.microso
ftonline.com/', UserId:'[email protected]'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://management.core.windows.net//.default ] ParentRequestId: 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] [Internal cache] Clearing user token cache accessor.
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] [Internal cache] Total number of cache partitions found while getting refresh tokens: 1
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 601d19ba-44cb-4df5-b050-be1827208731] IsLegacyAdalCacheEnabled: yes
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 601d19ba-44cb-4df5-b050-be1827208731] [Region discovery] Not using a regional authority. 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 601d19ba-44cb-4df5-b050-be1827208731] [Region discovery] Not using a regional authority. 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 601d19ba-44cb-4df5-b050-be1827208731] IsLegacyAdalCacheEnabled: yes
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 601d19ba-44cb-4df5-b050-be1827208731] IsLegacyAdalCacheEnabled: yes
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] Found 1 cache accounts and 0 broker accounts
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] Returning 1 accounts
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] MSAL MSAL.CoreCLR with assembly version '4.65.0.0'. CorrelationId(34ff850c-8
3fc-45ba-ae8b-0a20a2e9c890)
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] === AcquireTokenSilent Parameters ===
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] LoginHint provided: False
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] Account provided: True
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] ForceRefresh: False
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] 
=== Request Data ===
Authority Provided? - True
Scopes - https://management.core.windows.net//.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890
UserAssertion set: False
LongRunningOboCacheKey set: False
Region configured: 

DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] === Token Acquisition (SilentRequest) started:
	 Scopes: https://management.core.windows.net//.default
	Authority Host: login.microsoftonline.com
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] [Internal cache] Clearing user token cache accessor.
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] [Internal cache] Total number of cache partitions found while getting access
 tokens: 1
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] [FindAccessTokenAsync] Discovered 5 access tokens in cache using partition k
ey: 7bf02700-7865-4cca-bc77-f8044d2a1887.cxxxxxxxxx
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] [Region discovery] Not using a regional authority. 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] Access token is not expired. Returning the found cache entry. [Current time 
(05/29/2025 21:55:31) - Expiration Time (05/29/2025 22:15:30 +00:00) - Extended Expiration Time (05/29/2025 22:15:30 +00:00)]
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] Returning access token found in cache. RefreshOn exists ? False
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] [Region discovery] Not using a regional authority. 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] 
	=== Token Acquisition finished successfully:
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890]  AT expiration time: 5/29/2025 10:15:30 PM +00:00, scopes: https://managemen
t.core.windows.net//.default https://management.core.windows.net//user_impersonation. source: Cache
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] 
[LogMetricsFromAuthResult] Cache Refresh Reason: NotApplicable
[LogMetricsFromAuthResult] DurationInCacheInMs: 0
[LogMetricsFromAuthResult] DurationTotalInMs: 6
[LogMetricsFromAuthResult] DurationInHttpInMs: 0
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 34ff850c-83fc-45ba-ae8b-0a20a2e9c890] TokenEndpoint: ****
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://management.core.windows.net//.default ] ParentRequestId:  ExpiresOn: 2025-05-29T22:15:30.0000000+00:00
DEBUG: [Common.Authentication]: Received token with LoginType 'User', Tenant: 'cxxxxxxxxx', UserId: '[email protected]'
DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/servers/sql-elastiDB-01/jobAgents/ElastijobAgent-01/privat
eEndpoints/pep-xyz-01?api-version=2023-05-01-preview

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182
accept-language               : en-US

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
NotFound

Headers:
Pragma                        : no-cache
x-ms-request-id               : ad1fc49e-71d4-435e-b5a0-953878472c1b
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : x
x-ms-routing-request-id       : WESTUS2:20250529T215531Z:3d404588-72a6-4eff-bcab-2e1254a2832f
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: 0xxxx Ref B: CO6xxxx11 Ref C: 2025-05-29T21:55:31Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:55:31 GMT

Body:
{
  "error": {
    "code": "ResourceNotFound",
    "message": "The requested resource of type 'Microsoft.Sql/servers/jobAgents/privateEndpoints' with name 'pep-xyz-01' was not found."
  }
}
#############################

###### Here is where it stops until I manually appove the Private Enpoint ##############

#############################


DEBUG: [Common.Authentication]: Authenticating using Account: '[email protected]', environment: 'AzureCloud', tenant: 'cxxxxxxxxx'
DEBUG: 3:55:31 PM - [ConfigManager] Got nothing from [DisableInstanceDiscovery], Module = [], Cmdlet = []. Returning default value [False].
DEBUG: 3:55:31 PM - [ConfigManager] Got [False] from [EnableLoginByWam], Module = [], Cmdlet = [].
DEBUG: 3:55:31 PM - [SilentAuthenticator] Calling SharedTokenCacheCredential.GetTokenAsync - TenantId:'cxxxxxxxxx', Scopes:'https://management.core.windows.net//.default', AuthorityHost:'https://login.microso
ftonline.com/', UserId:'[email protected]'
DEBUG: SharedTokenCacheCredential.GetToken invoked. Scopes: [ https://management.core.windows.net//.default ] ParentRequestId: 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] [Internal cache] Clearing user token cache accessor.
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] [Internal cache] Total number of cache partitions found while getting refresh tokens: 1
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 222bc0ac-c535-4342-af60-f5066235cda8] IsLegacyAdalCacheEnabled: yes
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 222bc0ac-c535-4342-af60-f5066235cda8] [Region discovery] Not using a regional authority. 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 222bc0ac-c535-4342-af60-f5066235cda8] [Region discovery] Not using a regional authority. 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 222bc0ac-c535-4342-af60-f5066235cda8] IsLegacyAdalCacheEnabled: yes
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 222bc0ac-c535-4342-af60-f5066235cda8] IsLegacyAdalCacheEnabled: yes
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] Found 1 cache accounts and 0 broker accounts
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] Returning 1 accounts
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] MSAL MSAL.CoreCLR with assembly version '4.65.0.0'. CorrelationId(345518fd-0
ee3-4dcd-bb66-7a1af3fbe273)
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] === AcquireTokenSilent Parameters ===
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] LoginHint provided: False
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] Account provided: True
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] ForceRefresh: False
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] 
=== Request Data ===
Authority Provided? - True
Scopes - https://management.core.windows.net//.default
Extra Query Params Keys (space separated) - 
ApiId - AcquireTokenSilent
IsConfidentialClient - False
SendX5C - False
LoginHint ? False
IsBrokerConfigured - False
HomeAccountId - False
CorrelationId - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273
UserAssertion set: False
LongRunningOboCacheKey set: False
Region configured: 

DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] === Token Acquisition (SilentRequest) started:
	 Scopes: https://management.core.windows.net//.default
	Authority Host: login.microsoftonline.com
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z] [Internal cache] Clearing user token cache accessor.
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] [Internal cache] Total number of cache partitions found while getting access
 tokens: 1
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] [FindAccessTokenAsync] Discovered 5 access tokens in cache using partition k
ey: 7bf02700-7865-4cca-bc77-f8044d2a1887.cxxxxxxxxx
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] [Region discovery] Not using a regional authority. 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] Access token is not expired. Returning the found cache entry. [Current time 
(05/29/2025 21:55:31) - Expiration Time (05/29/2025 22:15:30 +00:00) - Extended Expiration Time (05/29/2025 22:15:30 +00:00)]
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] Returning access token found in cache. RefreshOn exists ? False
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] [Region discovery] Not using a regional authority. 
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] 
	=== Token Acquisition finished successfully:
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273]  AT expiration time: 5/29/2025 10:15:30 PM +00:00, scopes: https://managemen
t.core.windows.net//.default https://management.core.windows.net//user_impersonation. source: Cache
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] 
[LogMetricsFromAuthResult] Cache Refresh Reason: NotApplicable
[LogMetricsFromAuthResult] DurationInCacheInMs: 0
[LogMetricsFromAuthResult] DurationTotalInMs: 5
[LogMetricsFromAuthResult] DurationInHttpInMs: 0
DEBUG: False MSAL 4.65.0.0 MSAL.CoreCLR .NET Framework 4.8.9300.0 Microsoft Windows 10.0.22631  [2025-05-29 21:55:31Z - 345518fd-0ee3-4dcd-bb66-7a1af3fbe273] TokenEndpoint: ****
DEBUG: SharedTokenCacheCredential.GetToken succeeded. Scopes: [ https://management.core.windows.net//.default ] ParentRequestId:  ExpiresOn: 2025-05-29T22:15:30.0000000+00:00
DEBUG: [Common.Authentication]: Received token with LoginType 'User', Tenant: 'cxxxxxxxxx', UserId: '[email protected]'
DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
PUT

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/servers/sql-elastiDB-01/jobAgents/ElastijobAgent-01/privateEndpoints/pep-xyz-01?api-version=2023-05-01-preview

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182
accept-language               : en-US

Body:
{
  "properties": {
    "targetServerAzureResourceId": "/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/servers/sql-dbservices-control-dev-wcus-01"
  }
}


DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
Accepted

Headers:
Pragma                        : no-cache
Retry-After                   : 15
Azure-AsyncOperation          : https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointAzure
AsyncOperation/56149af0-40d6-4633-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323838065&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgw
FgYDVQQDEw9BTUUgSU5GUkEgQ0EgMDEwHhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wzsRotE1BvnXmkPHf5qzRo5syGAX4RxmMgIIUgLZIOHaTmF4ODuUBJEtuj-wLrt2oPXZi6zKB3xRi3HvKjIA_JqE7voGmX4JoCoBFH2W6-uScSN9UipSQdm0e5QXj6rUB16nESwXcQpO1DP2dCCWcVHp
BHmqK6Ciqmz5qkv4fIfG2HZg&h=kp3txK0f4a5QqqJ_n5XFkoSUmJVwQf1iTFzYBrBLT74
x-ms-request-id               : 56149af0-40d6-4633-a65f-26b161334108
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/b1ef907a-539e-471f-8f23-1d652621dbb1
x-ms-ratelimit-remaining-subscription-writes: 199
x-ms-ratelimit-remaining-subscription-global-writes: 2999
x-ms-correlation-request-id   : 5192d7c3-ed79-4920-8bca-390d328fcaac
x-ms-routing-request-id       : WESTUS2:20250529T215532Z:5192d7c3-ed79-4920-8bca-390d328fcaac
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: 5DD6701CB3F041FD9BA138125532CF57 Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:55:31Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:55:31 GMT
Location                      : https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointOpera
tionResults/56149af0-40d6-4633-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323994252&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgwFgY
DVQQDEw9BTUUgSU5GUkEgQ0EgMDEwHhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wPAYDVQQDEzVtgiZ00V2pHuk1qbOdhlzTDv8G0HZLm_T7_s92OBqMAwBJ1uChKnQm6M&s=ppHN621_3H3jNn512KJmCrKHlpZno9PCKnV2ba2gIvr1JsB0TckCK5DN4DBy0tCFsN7lAcsjqvLRHF3YrLg2Fzg
Zw2YcnX0UyZj98L8b_DWS3g1Fird4QLaCNGUB7GftgRm4GXBx-RpPZtma_4eYQczYuxplSEkHu45H_CprQb2tmx0NKV3XNacwEDPzp5exKQpnC7wAQ_YbhabdNZdjQxGKNzo2C-3tCLMlyz09KnJleXFgrHpqZPMKbX7w2OvhvuCm0HRgzSc898buNR-bA7zFcr8iLzz349HX2ANSsp7atFPrX0vknNRBw2z6Nx0bU
y8pHjOYD0KtKGKcHVbUXA&h=-KP8BO2gU5lEJlsLjsr8NG9zjllp3-2TPNaRD2P0QNM

Body:
{
  "operation": "UpsertJobAccountPrivateLink",
  "startTime": "2025-05-29T21:55:32.33Z"
}


DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointAzureAsyncOperation/56149af0-40d6-463
3-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323838065&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgwFgYDVQQDEw9BTUUgSU5GUkEgQ0EgMDEw
HhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wPAYDVQQDEzVhc3luY29wZXJhdGlvbnNpZ25IsydOGq5NSpxte9Cy10m7-zSXWMn0yNE8YUToarDNRzmshQ5pEBXhjU6kSMEvqeNG8Fr3KrDZEVieQc5By_ZV8F9vtuv90XjrjiLw1qOrPVVvUFOTx-JlUR4aErF4Jldd_YA0aWCiYbvu3Bd1vW
tXdnrkJSX-natlKNqGimVnj86nKEao8ktK5pKaHq6C8vbOLeNreXRy5C2fC1tgiZ00V2pHuk1qbOdhlzTDv8G0HZLm_T7_s92OBqMAwBJ1uChKnQm6M&s=FI7BaVj7xyj3qjZk1Q15W2QocAeGzvCHAxSHnZPatOS-W60tLEL7XIXhUsGSUbSVDlzr6rECUl6-ze2En9HMhPC8l8fEujQ26lYczakfXa-upddFOYz4
b73_oX1f1jqkEWG4UR4XoGwCIqfirV5UXt9-aVfLEGg0xMX80gizsRotE1BvnXmkPHf5qzRo5syGAX4RxmMgIIUgLZIOHaTmF4ODuUBJEtuj-wLrt2oPXZi6zKB3xRi3HvKjIA_JqE7voGmX4JoCoBFH2W6-uScSN9UipSQdm0e5QXj6rUB16nESwXcQpO1DP2dCCWcVHpBHmqK6Ciqmz5qkv4fIfG2HZg&h=kp3tx
K0f4a5QqqJ_n5XFkoSUmJVwQf1iTFzYBrBLT74

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Pragma                        : no-cache
Retry-After                   : 15
x-ms-request-id               : 3b3eac57-1c64-45d3-a801-45de8894fe25
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/8a908abe-e0e1-48c0-8770-14e9efc7fdf7
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : 8d962443-c305-4dd1-a0e1-c46599106904
x-ms-routing-request-id       : WESTUS2:20250529T215547Z:8d962443-c305-4dd1-a0e1-c46599106904
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: FED85C62C3FB488B9731367D975924D6 Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:55:47Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:55:46 GMT

Body:
{
  "name": "56149af0-40d6-4633-a65f-26b161334108",
  "status": "InProgress",
  "startTime": "2025-05-29T21:55:32.33Z"
}


DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointAzureAsyncOperation/56149af0-40d6-463
3-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323838065&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgwFgYDVQQDEw9BTUUgSU5GUkEgQ0EgMDEw
HhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wPAYDVQQDEzVhc3luY29wZXJhdGlvbnNpZ25pbmdjZs92OBqMAwBJ1uChKnQm6M&s=FI7BaVj7xyj3qjZk1Q15W2QocAeGzvCHAxSHnZPatOS-W60tLEL7XIXhUsGSUbSVDlzr6rECUl6-ze2En9HMhPC8l8fEujQ26lYczakfXa-upddFOYz4
b73_oX1f1jqkEWG4UR4XoGwCIqfirV5UXt9-aVfLEGg0xMX80gizsRotE1BvnXmkPHf5qzRo5syGAX4RxmMgIIUgLZIOHaTmF4ODuUBJEtuj-wLrt2oPXZi6zKB3xRi3HvKjIA_JqE7voGmX4JoCoBFH2W6-uScSN9UipSQdm0e5QXj6rUB16nESwXcQpO1DP2dCCWcVHpBHmqK6Ciqmz5qkv4fIfG2HZg&h=kp3tx
K0f4a5QqqJ_n5XFkoSUmJVwQf1iTFzYBrBLT74

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Pragma                        : no-cache
Retry-After                   : 15
x-ms-request-id               : d7784f0c-4b74-4519-ba47-47125ef5c24c
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/0a113d0c-d699-4be3-ba7a-3d631a6303c5
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : c565c689-17b8-4306-9802-ae2099780a76
x-ms-routing-request-id       : WESTUS2:20250529T215602Z:c565c689-17b8-4306-9802-ae2099780a76
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: E5171D74BCE04C6085B7782A26757279 Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:56:02Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:56:02 GMT

Body:
{
  "name": "56149af0-40d6-4633-a65f-26b161334108",
  "status": "InProgress",
  "startTime": "2025-05-29T21:55:32.33Z"
}


DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointAzureAsyncOperation/56149af0-40d6-463
3-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323838065&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgwFgYDVQQDEw9BTUUgSU5GUkEgQ0EgMDEw
HhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wPAYDVQQDEzVhc3luY29wZXJhdGlvbnNpZ25pbmdjZXJ0aWZpY2F0ZS5tYW5hZ2VtZW50LmF6dXJlLmNvbTCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAPxDlNdj6r6H0vTzKfz228nqLQPXYSxPqEGQSSSCczQcCX3f_Xtnvc-lFdolea
y-OVQlgfbWiMkGazl2q7FVj9BZUHJ3KXFg833nlMDzzIkfrA17t4t3OW-6po21aPw9TdEBtH-RxmMgIIUgLZIOHaTmF4ODuUBJEtuj-wLrt2oPXZi6zKB3xRi3HvKjIA_JqE7voGmX4JoCoBFH2W6-uScSN9UipSQdm0e5QXj6rUB16nESwXcQpO1DP2dCCWcVHpBHmqK6Ciqmz5qkv4fIfG2HZg&h=kp3tx
K0f4a5QqqJ_n5XFkoSUmJVwQf1iTFzYBrBLT74

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Pragma                        : no-cache
Retry-After                   : 15
x-ms-request-id               : 0daf7389-b749-4fcf-a26b-e731e7bc6ecd
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/54ff5119-13d6-449a-a557-4fb87caf5670
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : 6e230ab3-4c17-483d-812d-403ba769466d
x-ms-routing-request-id       : WESTUS2:20250529T215617Z:6e230ab3-4c17-483d-812d-403ba769466d
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: 779E3CCC1EB5485C973934A2DE8433FA Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:56:17Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:56:17 GMT

Body:
{
  "name": "56149af0-40d6-4633-a65f-26b161334108",
  "status": "InProgress",
  "startTime": "2025-05-29T21:55:32.33Z"
}


DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointAzureAsyncOperation/56149af0-40d6-463
3-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323838065&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgwFgYDVQQDEw9BTUUgSU5GUkEgQ0EgMDEw
HhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wPAYDVQQDEzVhc3luY29wZXJh4RxmMgIIUgLZIOHaTmF4ODuUBJEtuj-wLrt2oPXZi6zKB3xRi3HvKjIA_JqE7voGmX4JoCoBFH2W6-uScSN9UipSQdm0e5QXj6rUB16nESwXcQpO1DP2dCCWcVHpBHmqK6Ciqmz5qkv4fIfG2HZg&h=kp3tx
K0f4a5QqqJ_n5XFkoSUmJVwQf1iTFzYBrBLT74

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Pragma                        : no-cache
Retry-After                   : 15
x-ms-request-id               : 6496fb13-2acd-4f88-aa63-dcafbce1699f
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/457cb581-3117-4c06-b45f-732dbbe98111
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : faa4c56b-ccc6-4b9d-8f9a-ff4acf519ca3
x-ms-routing-request-id       : WESTUS2:20250529T215633Z:faa4c56b-ccc6-4b9d-8f9a-ff4acf519ca3
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: B2228896D29B470F9732B053AF2DEC94 Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:56:32Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:56:32 GMT

Body:
{
  "name": "56149af0-40d6-4633-a65f-26b161334108",
  "status": "InProgress",
  "startTime": "2025-05-29T21:55:32.33Z"
}


DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointAzureAsyncOperation/56149af0-40d6-463
3-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323838065&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgwFgYDVQQDEw9BTUUgSU5GUkEgQ0EgMDEw
HhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wPAYDVQQDEzVhc3luY29wZXJhdX4RxmMgIIUgLZIOHaTmF4ODuUBJEtuj-wLrt2oPXZi6zKB3xRi3HvKjIA_JqE7voGmX4JoCoBFH2W6-uScSN9UipSQdm0e5QXj6rUB16nESwXcQpO1DP2dCCWcVHpBHmqK6Ciqmz5qkv4fIfG2HZg&h=kp3tx
K0f4a5QqqJ_n5XFkoSUmJVwQf1iTFzYBrBLT74

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Pragma                        : no-cache
Retry-After                   : 15
x-ms-request-id               : fe681fbe-96ee-4dff-996f-cfe72744557f
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/99913d37-92a2-4e71-a52f-c69ea53a25e5
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : 2f2bbcd8-b795-4138-ab84-fbb6410286b8
x-ms-routing-request-id       : WESTUS2:20250529T215648Z:2f2bbcd8-b795-4138-ab84-fbb6410286b8
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: 4E7DD9B165B044E5AF1222B93DB2190E Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:56:48Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:56:47 GMT

Body:
{
  "name": "56149af0-40d6-4633-a65f-26b161334108",
  "status": "InProgress",
  "startTime": "2025-05-29T21:55:32.33Z"
}


DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointAzureAsyncOperation/56149af0-40d6-463
3-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323838065&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgwFgYDVQQDEw9BTUUgSU5GUkEgQ0EgMDEw
HhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wPAYDVQQDEzVhc3luY2zRo5syGAX4RxmMgIIUgLZIOHaTmF4ODuUBJEtuj-wLrt2oPXZi6zKB3xRi3HvKjIA_JqE7voGmX4JoCoBFH2W6-uScSN9UipSQdm0e5QXj6rUB16nESwXcQpO1DP2dCCWcVHpBHmqK6Ciqmz5qkv4fIfG2HZg&h=kp3tx
K0f4a5QqqJ_n5XFkoSUmJVwQf1iTFzYBrBLT74

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Pragma                        : no-cache
Retry-After                   : 15
x-ms-request-id               : 1f8738e1-6bde-4ef4-aa54-4e026268e488
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/38142217-04db-461f-befe-5e139f824231
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : 973a57f6-183b-467c-b9e5-f979b00133b1
x-ms-routing-request-id       : WESTUS2:20250529T215703Z:973a57f6-183b-467c-b9e5-f979b00133b1
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: 1F7EF48125E143909FF19EE1FCB8E3F4 Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:57:03Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:57:02 GMT

Body:
{
  "name": "56149af0-40d6-4633-a65f-26b161334108",
  "status": "InProgress",
  "startTime": "2025-05-29T21:55:32.33Z"
}


DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointAzureAsyncOperation/56149af0-40d6-463
3-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323838065&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgwFgYDVQQDEw9BTUUgSU5GUkEgQ0EgMDEw
HhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wPAYDVQQDEzVhc3luYqzRo5syGAX4RxmMgIIUgLZIOHaTmF4ODuUBJEtuj-wLrt2oPXZi6zKB3xRi3HvKjIA_JqE7voGmX4JoCoBFH2W6-uScSN9UipSQdm0e5QXj6rUB16nESwXcQpO1DP2dCCWcVHpBHmqK6Ciqmz5qkv4fIfG2HZg&h=kp3tx
K0f4a5QqqJ_n5XFkoSUmJVwQf1iTFzYBrBLT74

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Pragma                        : no-cache
Retry-After                   : 15
x-ms-request-id               : fa0378c6-529a-4237-a821-087903475ffe
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/b7c4cbd9-463f-4e6a-8a26-a38a1b2a5ef6
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : 1a3ecc70-7b44-40cc-853a-51296bbc8f3f
x-ms-routing-request-id       : WESTUS2:20250529T215718Z:1a3ecc70-7b44-40cc-853a-51296bbc8f3f
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: 7F565F1349F7404EB46ADE79B4AF6050 Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:57:18Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:57:17 GMT

Body:
{
  "name": "56149af0-40d6-4633-a65f-26b161334108",
  "status": "InProgress",
  "startTime": "2025-05-29T21:55:32.33Z"
}


DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/locations/westcentralus/jobAgentPrivateEndpointAzureAsyncOperation/56149af0-40d6-463
3-a65f-26b161334108?api-version=2023-05-01-preview&t=638841525323838065&c=MIIHpTCCBo2gAwIBAgITOgWZuFmLREgOyTdeugAEBZm4WTANBgkqhkiG9w0BAQsFADBEMRMwEQYKCZImiZPyLGQBGRYDR0JMMRMwEQYKCZImiZPyLGQBGRYDQU1FMRgwFgYDVQQDEw9BTUUgSU5GUkEgQ0EgMDEw
HhcNMjUwNDE5MTQyMjI3WhcNMjUxMDE2MTQyMjI3WjBAMT4wPAYDVQQDEzVhc35qzRo5syGAX4RxmMgIIUgLZIOHaTmF4ODuUBJEtuj-wLrt2oPXZi6zKB3xRi3HvKjIA_JqE7voGmX4JoCoBFH2W6-uScSN9UipSQdm0e5QXj6rUB16nESwXcQpO1DP2dCCWcVHpBHmqK6Ciqmz5qkv4fIfG2HZg&h=kp3tx
K0f4a5QqqJ_n5XFkoSUmJVwQf1iTFzYBrBLT74

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Pragma                        : no-cache
Retry-After                   : 15
x-ms-request-id               : 56e0a99f-bae9-4cae-814e-5c7b0ee68d0b
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/684fa0ab-f351-4b97-bafd-83e770f8fbac
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : d9162628-eed4-4750-ae62-df485d6da693
x-ms-routing-request-id       : WESTUS2:20250529T215733Z:d9162628-eed4-4750-ae62-df485d6da693
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: 2E35D38F2EBF46599F0DCA6865411290 Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:57:33Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:57:33 GMT

Body:
{
  "name": "56149af0-40d6-4633-a65f-26b161334108",
  "status": "Succeeded",
  "startTime": "2025-05-29T21:55:32.33Z"
}


DEBUG: ============================ HTTP REQUEST ============================

HTTP Method:
GET

Absolute Uri:
https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/servers/sql-elastiDB-01/jobAgents/ElastijobAgent-01/privat
eEndpoints/pep-xyz-01?api-version=2023-05-01-preview

Headers:
x-ms-client-request-id        : b08e5592-26a3-4dd6-9279-9231449ce182

Body:



DEBUG: ============================ HTTP RESPONSE ============================

Status Code:
OK

Headers:
Pragma                        : no-cache
x-ms-request-id               : ace1a69e-fa43-4ed1-935f-a9fa0a8f1a12
x-ms-operation-identifier     : tenantId=cxxxxxxxxx,objectId=7bf02700-7865-4cca-bc77-f8044d2a1887/westus2/010f2df1-fe56-4795-9e32-7ffa200ad19b
x-ms-ratelimit-remaining-subscription-reads: 249
x-ms-ratelimit-remaining-subscription-global-reads: 3749
x-ms-correlation-request-id   : eef9c1a5-7e9a-4cd6-8d97-86da1169792b
x-ms-routing-request-id       : WESTUS2:20250529T215734Z:eef9c1a5-7e9a-4cd6-8d97-86da1169792b
Strict-Transport-Security     : max-age=31536000; includeSubDomains
X-Content-Type-Options        : nosniff
X-Cache                       : CONFIG_NOCACHE
X-MSEdge-Ref                  : Ref A: 397ED9A769954D50AE99EE220D022FD0 Ref B: CO6AA3150220031 Ref C: 2025-05-29T21:57:33Z
Cache-Control                 : no-cache
Date                          : Thu, 29 May 2025 21:57:33 GMT

Body:
{
  "properties": {
    "targetServerAzureResourceId": "/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/servers/sql-dbservices-control-dev-wcus-01",
    "privateEndpointId": "EJ_481b3bb9-8a83-4e79-9df9-e61faadd447b_pep-sqlja-sql-dbservices"
  },
  "id": "/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/servers/sql-elastiDB-01/jobAgents/ElastijobAgent-01/privateEndpoints/pep-sqlj
a-sql-dbservices-control-dev-wcus-01",
  "name": "pep-xyz-01",
  "type": "Microsoft.Sql/servers/jobAgents/privateEndpoints"
}


DEBUG: 3:57:34 PM - [ConfigManager] Got nothing from [DisplaySecretsWarning], Module = [], Cmdlet = []. Returning default value [True].


PrivateEndpointName         : pep-xyz-01
TargetServerAzureResourceId : /subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/servers/sql-dbservices-control-dev-wcus-01
PrivateEndpointId           : EJ_481b3bb9-8aadd447b_pep-sqlja-sql-dbservices
ResourceGroupName           : rg-xxxxx
ServerName                  : sql-elastiDB-01
AgentName                   : ElastijobAgent-01
ResourceId                  : /subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/servers/sql-elastiDB-01/jobAgents/ElastijobAgent-01/pri
                              vateEndpoints/pep-xyz-01
Type                        : Microsoft.Sql/servers/jobAgents/privateEndpoints

DEBUG: 3:57:34 PM - [ConfigManager] Got nothing from [DisplayRegionIdentified], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: 3:57:34 PM - [ConfigManager] Got nothing from [CheckForUpgrade], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: 3:57:34 PM - No authentication telemetry is found for the current cmdlet with Id b08e5592-26a3-4dd6-9279-9231449ce182.
DEBUG: AzureQoSEvent:  Module: Az.Sql:6.0.4; CommandName: New-AzSqlElasticJobPrivateEndpoint; PSVersion: 5.1.22621.4391; IsSuccess: True; Duration: 00:02:02.6448750; SanitizeDuration: 00:00:00.0000792
DEBUG: 3:57:34 PM - [ConfigManager] Got nothing from [EnableDataCollection], Module = [], Cmdlet = []. Returning default value [True].
DEBUG: 3:57:34 PM - NewAzureSqlElasticJobPrivateEndpoint end processing.

Environment data

Name                           Value                                                                                                                                                                                                     
----                           -----                                                                                                                                                                                                     
PSVersion                      5.1.22621.4391                                                                                                                                                                                            
PSEdition                      Desktop                                                                                                                                                                                                   
PSCompatibleVersions           {1.0, 2.0, 3.0, 4.0...}                                                                                                                                                                                   
BuildVersion                   10.0.22621.4391                                                                                                                                                                                           
CLRVersion                     4.0.30319.42000                                                                                                                                                                                           
WSManStackVersion              3.0                                                                                                                                                                                                       
PSRemotingProtocolVersion      2.3                                                                                                                                                                                                       
SerializationVersion           1.1.0.1

Module versions

> get-module az*

ModuleType Version    Name                                ExportedCommands                                                                                                                                                               
---------- -------    ----                                ----------------                                                                                                                                                               
Script     5.0.1      Az.Accounts                         {Add-AzEnvironment, Clear-AzConfig, Clear-AzContext, Clear-AzDefault...}                                                                                                       
Script     7.16.2     Az.Network                          {Add-AzApplicationGatewayAuthenticationCertificate, Add-AzApplicationGatewayBackendAddressPool, Add-AzApplicationGatewayBackendHttpSetting, Add-AzApplicationGatewayBackendS...
Script     8.0.0      Az.Resources                        {Export-AzResourceGroup, Export-AzTemplateSpec, Get-AzDenyAssignment, Get-AzDeployment...}                                                                                     
Script     6.0.4      Az.Sql                              {Add-AzSqlDatabaseToFailoverGroup, Add-AzSqlElasticJobStep, Add-AzSqlElasticJobTarget, Add-AzSqlInstanceKeyVaultKey...}

Error output


      		
    

      
  





        



            
            

              
            

        

      


      
    








      

    



      

  
            

    

      
    

    


      

          @lostsole
lostsole




            added
      

  bug

  This issue requires a change to an existing behavior in the product in order to be resolved.

      

  needs-triage

  This is a new issue that needs to be triaged to the appropriate team.

  labels


      May 29, 2025

    

  



    

    

      
    

    


      

          @microsoft-github-policy-service
microsoft-github-policy-service
bot



            added
      

  customer-reported


      

  needs-triage

  This is a new issue that needs to be triaged to the appropriate team.

    and removed
      

  needs-triage

  This is a new issue that needs to be triaged to the appropriate team.

  labels


      May 29, 2025

    

  








      

  
      



  

  @lostsole





  


    

      

  

    

        
    
    

  


      
          
  
      
            Copy link

  

      
    

  


  

      



      

  Author


  


  

    

  





      


        


  
    

      
          
Using this code the process does not hang!  Please explain this one as it uses the same API version and the ( Terraform, and the New-AzSqlElasticJobPrivateEndpoint where the process hangs Unless the Private link is approved in the Azure portal )


$SourceResourceGroupName='rg-xxxxx';

$PrivateEndpointName='pep-xyz-01';

$ElasticJobAgentName='ElastijobAgent-01';

$SourceServerName='sql-elastiDB-01'

$SubscriptionId = (Get-AzContext).Subscription.Id;

$TargetServerName='sql-xxxxxxxxx-01';

$TargetServerAzureResourceId = (Get-AzResource -Name $TargetServerName).ResourceId;


    # Create private endpoint link
    $Body = @{
        properties = @{
            targetServerAzureResourceId = $TargetServerAzureResourceId
        }
    }

    $JsonBody = $Body | ConvertTo-Json -Depth 100 -Compress

    # Build the required parameters
    $FunctionInput = @{
        SubscriptionId = $SubscriptionId
        ResourceGroupName = $SourceResourceGroupName
        ResourceProviderName = 'Microsoft.Sql'
        ResourceType = "servers/$SourceServerName/jobagents/$ElasticJobAgentName/privateEndpoints/$PrivateEndpointName"
        Payload = $JsonBody
        Method = 'Put'
        ApiVersion = '2024-05-01-preview'
    }

    #Write-Verbose -Message ("Creating private link endpoint ::: {0}" -f $PrivateEndpointName)
    Invoke-AzRestMethod @FunctionInput -Verbose


      		
    

  





        


            

            
            

              
            

        

      


      

            
  
  

    
  
    
    

  

  

  


    












      

  
      



  

  @lostsole





  


    

      

  

    

        
    
    

  


      
          
  
      
            Copy link

  

      
    

  


  

      



      

  Author


  


  

    

  





      


        


  
    

      
          
Could it be that the code first try's to Get and this is the issue,  As the code I shown above is doing a put, and the put part of the code above in the Debug works


DEBUG: ============================ HTTP REQUEST ============================


HTTP Method:

GET


Absolute Uri:

https://management.azure.com/subscriptions/xxxxxxxxxx-yyyyyyyy/resourceGroups/rg-xxxxx/providers/Microsoft.Sql/servers/sql-elastiDB-01/jobAgents/ElastijobAgent-01/privat

eEndpoints/pep-xyz-01?api-version=2023-05-01-preview

      		
    

  





        


            

            
            

              
            

        

      


      

            
  
  

    
  
    
    

  

  

  


    












      

  
          

  

    
  


  

      

    @lostsole
lostsole



    mentioned this issue
    
      Jun 2, 2025
    





  


  

      
  
  Open

  







  









      

  
      



  

  @lostsole





  


    

      

  

    

        
    
    

  


      
          
  
      
            Copy link

  

      
    

  


  

      



      

  Author


  


  

    

      

      
            lostsole
  

      

      

      commented


        Jun 2, 2025


      
    


  





      


        


  
    

      
          
Powershell code that will create the endpoint without hanging:

based off this code: https://gist.github.com/Gijsreyn/383af1ed981a990782964e27f1adeaeb


function invoke-Putblock {
    param (
        [string]$TargetServerAzureResourceId,
        [string]$SourceServerName,
        [string]$ElasticJobAgentName,
        [string]$PrivateEndpointName,
        [string]$SubscriptionId,
        [string]$SourceResourceGroupName
    )

    try {
        
        $Body = @{
            properties = @{
                targetServerAzureResourceId = $TargetServerAzureResourceId
            }
        }

        $JsonBody = $Body | ConvertTo-Json -Depth 100 -Compress

        # Build the required parameters
        $FunctionInput = @{
            SubscriptionId = $SubscriptionId
            ResourceGroupName = $SourceResourceGroupName
            ResourceProviderName = 'Microsoft.Sql'
            ResourceType = "servers/$SourceServerName/jobagents/$ElasticJobAgentName/privateEndpoints/$PrivateEndpointName"
            Payload = $JsonBody
            Method = 'Put'
            ApiVersion = '2024-05-01-preview'
        }

        Invoke-AzRestMethod @FunctionInput; #-Verbose

Start-Sleep -Seconds 30

        #Write-Output "Command executed successfully: $Result"
        return $true
    } catch {
        #Write-Error "Error executing command: $Result"
        return $false
    }
}

$rgResult   = invoke-Putblock -TargetServerAzureResourceId $TargetServerAzureResourceId -SourceServerName $SourceServerName -ElasticJobAgentName $ElasticJobAgentName -PrivateEndpointName $PrivateEndpointName -SubscriptionId $SubscriptionId -SourceResourceGroupName $SourceResourceGroupName; 


      		
    

  





        


            

            
            

              
            

        

      


      

            
  
  

    
  
    
    

  

  

  


    












      

  
            

    

      
    

    


      

          @isra-fel
isra-fel




            added
      

  SQL - Elastic Jobs


      

  Service Attention

  This issue is responsible by Azure service team.

    and removed
      

  needs-triage

  This is a new issue that needs to be triaged to the appropriate team.

  labels


      Jun 5, 2025

    

  








      

  
      



  

  @microsoft-github-policy-service

    
      Microsoft GitHub Policy Service
    




  


    

      

  

    

        
    
    

  


      
          
  
      
            Copy link

  

      
    

  


  

      

  
    Contributor


      

  


  

    

  





      


        


  
    

      
          
Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub.


      		
    

  





        


            

            
            

              
            

        

      


      

            
  
  

    
  
    
    

  

  

  


    











      

  
    

      
        1 similar comment
      
    

  
    

  
      



  

  @microsoft-github-policy-service

    
      Microsoft GitHub Policy Service
    




  


    

      

  

    

        
    
    

  


      
          
  
      
            Copy link

  

      
    

  


  

      

  
    Contributor


      

  


  

    

  





      


        


  
    

      
          
Thanks for the feedback! We are routing this to the appropriate team for follow-up. cc @azureSQLGitHub.


      		
    

  





        


            

            
            

              
            

        

      


      

            
  
  

    
  
    
    

  

  

  


    


















  
  

    

      

  





  




  
  

              

  
    Sign up for free
    to join this conversation on GitHub.
    Already have an account?
    Sign in to comment


  



  






  
                  




    

  


      
  

    Assignees
  



        

    No one assigned







      


  


  

    Labels
  



    

      

    bug

  This issue requires a change to an existing behavior in the product in order to be resolved.
  

    customer-reported

  

    Service Attention

  This issue is responsible by Azure service team.
  

    SQL - Elastic Jobs









      

  

    

        

    Projects
  


        




    None yet




  



      


  

    
  

    Milestone
  


      No milestone





    
      
          


  

    

      
        

          
    

    Development
  




            
    
No branches or pull requests







      
    

  




      

    

  
      

  

    

      2 participants
    

    

        
          @lostsole 
        
          @isra-fel