CODEWITHSUNDEEP
azure-data-factory
Data_Insight
Data_Insight

Reputation: 585

How send a notification once DataFactory Job runs or failed?

I wanted to send a notification once DataFactory Job runs or failed.

I don't want to send it through Logic apps and Azure alters.

Please suggest some way to manage this situation. enter image description here

Upvotes: 2

Views: 7139

Answers (3)

Jess
Jess

Reputation: 3725

I use webhook to send messages to Team. Here is the official template.

enter image description here

failed

here is my UI. I add a Lookup Activity to search a non-existent DB table to raise an error.

enter image description here

And then I connect it to copy activity.

enter image description here

succeeded

It's the same way, but not need to raise an error.

enter image description here

Upvotes: 0

DraganB
DraganB

Reputation: 1138

I would suggest a combination of Azure Function + SendGrid.

SendGrid is a cloud-based email service, and on a free pricing tier, you can send 25k emails. Support .NET,Java and Python (i think).

So write an azure function that will send an email via SendGrid. On pipeline failure, you will just call AF.

I would suggest you in this scenario to pay as you go for AF, and as I said free tier for SendGrid. Minimum cost.

https://learn.microsoft.com/en-us/azure/sendgrid-dotnet-how-to-send-email here you can find how to use SendGrid (code example)

https://azure.microsoft.com/en-us/blog/azure-functions-now-supported-as-a-step-in-azure-data-factory-pipelines/

Upvotes: 0

Jay Gong
Jay Gong

Reputation: 23782

As I know,ADF has own Alert/Monitor mechanism.Please see the button in the ADF portal as below.

enter image description here

You could create new Alert Rule.

enter image description here

Configure alert Criteria.

enter image description here

Configure alert channel.

enter image description here

Upvotes: 4

Related Questions