Stop the job if it takes more time

[bhagyarekha]

Hi Team,
I have one job ,that it enters records into the database.code and every thing was fine.
now my requirement is ,some times some problem with my database so my job is taking more time to start  (like one hr for 40000 records).so in this case how can i handle my job to terminate the process based on the time.and what component can i place to get same long time taking to my mail
Awaiting for reply,
regards,
rekha 

[Anonymous]

Hi,


Here is a schema "Duration"which is time for the execution of a Job or a component with the tStatCatcher Statistics check box selected.
You send execution time for your job to your mail by using tSendmail component.
The whole work flow should be:
input source-->further processing-->t<DBoutput>--->Runif(condition: time)-->tdie

tstatcatcher-->tsendmail

Let us know if it is Ok with you.
Best regards
Sabrina

[bhagyarekha]

Hi,
Thanks for your reply!
Can you tell how to write condition for time in java.
for suppose i want my job to run within 5min but still the job is got stuck in database respond time.
after the 5 min got completed,automatically it should die and send me a mail.
how can i capture the 5 min got completed from the start time of job in if condition.
Regards,
Rekha

[bhagyarekha]

Hi,
Am  using as you told ,but when ever i start running my job,irrespective of time am getting mail from tstatcatcher and the job is running as usally.