Database Software

hi experts,

we have a scheduled job which execute a procedure every 15 min....the procedure is written so that it take data in a cursor from remote location, and insert it into a table on server...

it was working fine , but at 6 AM in morning the link is disconnected from remote location (as it it connected through lease line and RF) then oracle did not try to execute the job, and when i see running jobs it shows that job still running from 6 AM in morning..

i have check all the views, dba_jobs, dba_scheduler_jobs but in no view or table it is shown broken...anyways now i have recreated it and is working fine,

but i would like to know how to force oracle to retry executing job if it is not executed on specified interval due to connection failure??? i read in oracle documentation that oracle try executing job if it is not executed after 1min, 2min, 4min and so on for 16 times, then declare it as broken....

and i also seen column "retry schedule" in dba_scheduler_jobs ....

so can anyone tell me how to schedule this retry explicitly????

thanks and regards
VD