Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a requirement in which I extract data from files and databases as source into target databases (mostly oracle).
But sometimes job fails because of some db connection errors like "Connection timed out" and "network adapter could not establish connection" like these. when such issues arise I would like the job to retry to connect again and again(for fixed number of times) until there is successful connection.
So can anyone help me on how can I achieve this instead of running the job manually when these errors occur?
Quick reply would be appreciated.
Thanks in advance.
Hi,
Sorry I didn't get you. Could you please elaborate if possible??
Hi,
PFA screenshot.
Is this the approach you are speaking about??
But I want the job to retry on its own for multiple times until the connection gets established.
Please correct me if i'm wrong on my requirement.
Hi ,
I have tried to implement the solution using tLoop
PFA screenshot.
code in tLoop(while loop) : i<=10 && context.status == false
I intentionally made the job to fail with connection error but still its making only 1 attempt instead of 10
which is defined in the loop.
tJava : im resetting the context.status = true if conn is fine.
Yes I have tried connecting the tLoop to tRun job which has the main connection check.
but after that how to proceed?
PFA screenshot.
It would be great if you have any sample job designed so that it will be easy for me.