Thanks for the reply.

tnsping is OS command. I know I can use DBMS_JOB or DBMS_SCHDULER. But what happens is if the dblink is down, then it takes forever to throw the error. Is it possible that if the db link is down, then the exception throws the errror immediately?