Five 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

5 REPLIES
Seven Stars

Re: Handling of success and failure

Hello,

 

Have you tried something like this?

 

Capture.JPG

 

 

 

 

 

 

 

 

 

Regards
lojdr

Thirteen Stars TRF
Thirteen 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
Five 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

 

Five 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.

Thirteen Stars TRF
Thirteen Stars

Re: Handling of success and failure

Great!

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


TRF