Question 103758 in Azure Question posted in
The official documentation to get you started can be found here.

Automated email when connection to source fails in Azure

sorry if the question is too basic. I am very new to Azure and I want to receive automated email if a connection to for example a SQL server is not established. In that regard, I was wondering if there is anything like get meta data activity for linked services that could output true or false if a connection is is not established? given that there is such activity, I know how to to the rest of job. I would appreciate it if someone could help.

Thanks in advance

I have searched about it and tried to find the option of linkedservice instead of dataset in some activities settings but have not figured it out yet.

Tags:

2

Answers


  1. 0

    You can make use of Logic App in Azure with your Azure Data factory to receive an email when there’s an error.

    1. I created a Logic app resource with the connectors as mentioned below:-

    enter image description here

    enter image description here

    1. I created an ADF pipeline and sent an email on my Outlook when I received an error like below:-

    My copy data activity failed like below:-

    enter image description here

    Now, I’ll add one control flow on Web Activity that will trigger our Logic app to send an Email alert.

    Added my Logic app URL in the Web activity URL and content-type set to application/json :
    enter image description here

    enter image description here

    Added the dynamic content in the body to get the Error message and details in the email:-

    enter image description here

    enter image description here

    As the Copy activity failed, I got an email alert like below:-

    enter image description here

    Reference:-
    https://learn.microsoft.com/en-us/azure/data-factory/how-to-send-email

    Login or Signup to reply.
  2. 0

    How about getting an text message with email ? 🙂
    You can create monitoring on a pipeline and on failure it will send an email and also a text message . Please read more on the same here https://azure.microsoft.com/en-us/blog/create-alerts-to-proactively-monitor-your-data-factory-pipelines/.

    Now for the pipeline , you can add a Lookup actvity and add a simple query like

    "Select top 1 from someTable"

    When the connection to the SQL will fail , the activity will fail and also the pipeline . You should get and email and text for the failures .

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search