Search code examples
azureazure-data-factoryazure-alerts

Data factory - Integration runtime status alert


Am having multiple self hosted Integration Runtimes in my data factory. I need an alert rule via Mail, once the status changes from Running to Limited or anything else than Running: enter image description here
 
 

Unfortunately, i can't any matching metric for my case - any ideas how to solve this? enter image description here

Example:
In this case I'd like to get a mail every hour, since one integration runtime is not Running:

enter image description here


Solution

  • Data factory Alert rules does not provide any specific alert rule to check the status of Integration runtime.

    To achieve your goal, you need to create a logic app to send mail when Integration runtime in not running with the help of Rest API.

    concat('https://management.azure.com/subscriptions/<SubscriptionId>/resourceGroups/<resource-group-name>/providers/Microsoft.DataFactory/factories/<DF-name>/integrationRuntimes/',item().name,'/getStatus?api-version=2018-06-01')
    

    enter image description here

    • Then take an if condition to send mail if state is other than online body('HTTP_1').properties.state enter image description here

    • In true take a Send an email (V2) 1 to send email sing in with you email and appropriate values as below. enter image description here

    Output:

    Note: I checked for whether state is equal to online.

    Got an email enter image description here