How to kill/Abort job when it is stuck while establishing connection

[sacuke1]

Hi,

I am trying to kill/Abort job when it is stuck while establishing JDBC connection.

Sometimes it happens that JDBC connection failed to establish and instead of failing my job is getting stuck at tJDBCconnection component. 

I tried to check the execution time and forcefully die the job but whenever i connect any the component to tJDBCconnection, it stops working because it is stuck.

Please let me know if there is any solution in talend to fail the job automatically when it is stuck while connecting to database 

[Anonymous]

Hi @sacuke, 

I am not entirely sure what you are asking here. You say "...but whenever I connect any component to tJDBCConnection, it stops working because it is stuck". Do you mean when you use the tJDBCConnection as the connection for another DB component, or when you physically connect it to it? Can you give us a screenshot of what you job looks like. That might help a little

Regards

Richard

[sacuke1]

Hi Richard,

I was trying to say that how to fail the job when it stuck at some component.

[sacuke1]

Hi Richard,

in the screenshot my job is stuck at tpostgrerow component and i have to kill this job automatically.

stuck job.PNG

[Anonymous]

Your connection isn't failing there. It looks like your truncate is taking a long time. You need to figure out why this is the case. If the database is doing something, the job will not just stop.

By the way, I would connect your Connection components with OnSubJobOK links and not OnComponentOK links.