Hi n_i,

Thanks for your reply but i have one doubt over here.

You gave the following script:

30 1 * * 1 . /home/yourloginid/.profile;sqlplus @/usr/myProc/procSample.sql


Is it not necessary to mention UserId, Password and Connection String to connect to oracle in the above line?
How it will be connected?