thanks for you response.

this is going to run everyday in the early morning so i have to schedule it to run. each day depending on the day of the week...

1) yes

2) yes

3) yes i can tnsping my Oracle DB.

btw, this is a cluster. i have installed the Oracle client onto one of my two host nodes for my SQL...