I have questions on build "Managed private endpoints" for the pipeline which copies data from azure SQL DB to azure Blob storage which will be scheduled for running once a month automatically.
My question 1 is: when I create new integration runtime, I have to set interactive authoring and the connection will auto terminated after 60 mins. Does that mean every time I have to manually enable interactive authoring? My status of connection always shows in red rectangle:
Only after manual enable it, the connect test could succeed.
And my managed private endpoint looks fine.
The question 2 is: even I choose Account selection method using "From Azure subscription", it would be back to "Enter manually", and seems this kind change could not be published, so the updating never to be saved. Any difference effect to pipeline between "From Azure subscription" and "Enter Manually"?
And now, even my pipeline can be run successfully once I manually enable interactive authoring, it would fail in future scheduled jobs as following, and status as "In progress":
Hope I explained my situation clear to you guys, and welcome any suggestions.