webhooksazure-analysis-servicesazure-runbook

Catch error when analysis services refresh fail through webhook ADF


I have a runbook that is called multiple times from ADF but with different parameters. What it does is that it just refresh different analysis services. I use the web activity in ADF

enter image description here

With POST method and in the Body i state which analysis service i want to refresh. Here is the code for the runbook: enter image description here

The runbook says that all jobs is completed enter image description here

But one of them have actually failed: enter image description here

Does anyone know how i can catch this error? Now i have no way of knowing that this has failed, except for going in to every job and look in details.


Solution

  • Does anyone know how i can catch this error? Now i have no way of knowing that this has failed, except for going in to every job and look in details.

    enter image description here

    Alternatively,There is another way to get to know the errors using Inbuilt queries in Logs Section Of Automation Account.

    enter image description here

    You can use below query which I have taken from Microsoft-Document:

    AzureDiagnostics 
    | where ResourceProvider == "MICROSOFT.AUTOMATION" and Category == "JobStreams" and StreamType_s == "Error" 
    | project TimeGenerated , RunbookName_s , StreamType_s , _ResourceId , ResultDescription , JobId_g
    

    Error is in Result description:

    enter image description here

    Note( to get logs of jobs you need to enable logging and tracing in inside the runbook):

    enter image description here