Search Results

I will give points to quirkasaurus. Thanks

It worked.

Thanks a lot lot :) appreciate it.

>>>what is the error message you're getting from the cron job?

I am not getting any error message ..it is just that the cron is overlooking the sqlplus line in the script and executes everything...

thats corrrect.

Would there is any thing that i need to check ?

I am not getting any clue on why the cron is not executing the sqlplus

Thanks
dreg

#!/bin/ksh
/oracle/u000/app/oracle/product/10204/GEN/bin/sqlplus -s <usr>/<pass>@<sid></home/dreg/sqlscript.sh

Hope this is what you are asking..

can some please help me?

>>>Without seeing the script cannot help much...


I have listed the script details above for your reference.

>>>Make sure you use full paths for your commands and logs, check cron log...

cron job not running the sqlplus command in shell script but the shell script works fine from command line..

Cronjob:

5 * * * * /home/dreg/script.sh

script.sh:

#!/bin/ksh...