Handling of success and failure

Seven Stars

Handling of success and failure

Hi,

 

I want to create a job through which we want to handle the success and failures of the steps. Can some one please tell me how this can be done. Some tutorial or video for this could be of very much help.

 

Here is an example for your reference

Suppose we are fetching the results from stored procedure using tMSSQLSP component. How ever stored procedure got failed in that case we need to send email to the administrator informing him about the failure. And in case of success of stored procedure we want results fetched from tMSSQLSP component to be inserted to some data base table.

 

Regards

Tarunjit Singh


Accepted Solutions
Fifteen Stars TRF
Fifteen Stars

Re: Handling of success and failure

In most cases you should use a tLogCatcher to catch events such as warnings, errors or exceptions and decide in one place what to do when such an event occurs (log messages, send emails or anything else).

TRF

All Replies
Eight Stars

Re: Handling of success and failure

Hello,

 

Have you tried something like this?

 

Capture.JPG

 

 

 

 

 

 

 

 

 

Regards
lojdr

Fifteen Stars TRF
Fifteen Stars

Re: Handling of success and failure

In most cases you should use a tLogCatcher to catch events such as warnings, errors or exceptions and decide in one place what to do when such an event occurs (log messages, send emails or anything else).

TRF
Seven Stars

Re: Handling of success and failure

Hi,

 

Thanks for the answer.

 

When an exception occurs I want to log that error message in my data base table. for that I am using

 

tLogCatcher_1 > tMSSQLSP_2

 

Through tMSSQLSP_2  i am calling a stored procedure which will log the error message in to the data base table. But I am not getting the way to fetch the error message which caused flow to come to tLogCatcher_1.

 

Can some one please help me on this?

 

Regards

Tarunjit Singh

 

Seven Stars

Re: Handling of success and failure

Hi,

 

I have solved this issue. I got error message through tLogCatcher schema and got that error message in tMSSQLSP.

 

Thanks for helping.

Fifteen Stars TRF
Fifteen Stars

Re: Handling of success and failure

Great!

Thank's to mark this case as solved (Kudos also accepted).


TRF

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.