In Matillion, We have a TASK HISTORY which is really having detailed data. Is there any way I can use those data and trigger an email? like failure jobs task history or some specific job task history. Curious to know. Any suggestions, please

Matillion ETL
1

In Matillion, We have a TASK HISTORY which is really having detailed data. Is there any way I can use those data and trigger an email? like failure jobs task history or some specific job task history.

Curious to know. Any suggestions, please.

2

@Shan​ For a long everyone expecting this feature. Unfortunately as of now, we don't have an option in Matillion.

3

do we have any workaround to fetch those details?

4

Hello,

you can use the SNS notification component inside of your Matillion jobs, for example in case of an error.

If you need a seperate process you can read the complete task history details also via Matillion API, so you can create a seperate process for example outside of Matillion to read the task history by API, check details and send emails in case that jobs are failed.

5

Hello,

sorry for the late feedback, i was last week on vacation.

You can use the Version 0 of Matillion API to get informations from task history independent from project.

For this use for example "https://[your-instance-URL]/rest/v0/tasks?running=false&since=2021-06-28".

In this example you receive all tasks from today.

I hope this helps to fulfill your requirements.

 

Regards,

Dirk

6

@DirkZ​ Where we can find the Matillion API to get the task history?

7

I am looking for the same information.

8

Hello,

No problem! Hope you had a great vacation !

 

Let me try this approach and get back to you in case of any issues

9

Hi DirkZ,

 

I am using Matillion ETL

Version: 1.41.4 (build 417) and i have tried to follow the below post but i am unable to create a file itself.

Creating a Generic API Query Profile in Matillion | InterWorks

 

Any help or reference will be more helpful :)