Hi all,

there is my script,


#!/bin/bash
#!/bin/sh
. /home/dd/.sshConPrfl

WORK_DIR="directory; export WORK_DIR
SPOOL_DIR="directory"; export SPOOL_DIR
LOG_DIR=directory; export LOG_DIR
scr_name=scr
file_ext=txt
TODAY=`date +"%Y%m%d"`
LOG_DATE=`date +"%Y%m%d%H%M%S"`


sqlplus "my connection" @$WORK_DIR/mytest.sql $SPOOL_DIR/$scr_name"_"$TODAY".tmp"
$WORK_DIR > $LOG_DIR/$scr_name"_"$TODAY.log 2>&1

mv $SPOOL_DIR/$scr_name"_"$TODAY".tmp" $SPOOL_DIR/$scr_name"_"$TODAY"."$file_ext

when i run it in crontab, i saw the error below;
myscript.sh: line 29: sqlplus: command not found
mv: cannot stat ‘/20210317.tmp’: No such file or directory

but it works fine when i am running it with nohup. what could be the reason about why this script is not working with crontab? i checked the permissions and it seems fine. do you have any idea?

thannk you in advance.

PATH in crontab is usually set to /usr/bin:/bin by default (in Vixie Cron, at least). Either set PATH in the crontab file or (better) use the absolute path to sqlplus.

Or set the $PATH within the script.

Thank you for the answers. if possible could you please show me how to do it?

thank you.

How to do what? Where is sqlplus installed?

Take the output of the following,

Then put that in place of "foobar" below:

What do you have in /home/dd/.sshConPrfl and which distro is this task for?

Thank you all,
i did the same as you said.
but i am still getting the error like this below;

myscript.sh: line 29: sqlplus: command not found
mv: cannot stat ‘/myscript_20210318.tmp’: No such file or directory

what could be a problem?

Thank you, i did but i got the error as i shared above again.
what sould be the problem? i couldnt understand about it

1. use shellcheck to analyze your script
2. show your script, what you posted is just incorrect [syntactically].
3. did you adjust the variable PATH at all?

Hi, dear friend,
because of privacy i am not able to share all script there,
i couldnt send you private message, if there is a way to share it with you let me know and i can send it to you.
thank you in advance.

In that case you need to check if PATH was set correctly. Also please try shellcheck. Anyway without details hard to go further.

No one is asking for the entire script. Pair it down to the essential part that is not working and show us just that running
on its own and the associated error messages

Dear my friend,
there is the all script.
thank you.

#!/bin/bash
#!/bin/sh


. /home/user/.sshConPrfl


WORK_DIR=/script/de; export WORK_DIR
SPOOL_DIR=/script/de; export SPOOL_DIR
LOG_DIR=/script/log; export LOG_DIR
scr_name=de_tah
file_ext=txt
TODAY=`date +"%Y%m%d"`
LOG_DATE=`date +"%Y%m%d%H%M%S"`



sqlplus ****/TTS @$WORK_DIR/de_tah.sql $SPOOL_DIR/$scr_name"_"$TODAY".tmp"
$WORK_DIR > $LOG_DIR/$scr_name"_"$TODAY.log 2>&1

mv $SPOOL_DIR/$scr_name"_"$TODAY".tmp" $SPOOL_DIR/$scr_name"_"$TODAY"."$file_ext

and again, how is that PATH variable was set? (which is required to make it work)

Might I make a suggestion:

Take that filename construct you have pasted in numerous places:
and define it as a new variable:
and plug it in in place of the multiple instances so your two (three? see below) commands become:
With all those double quotes, you're bound to miss one and get one of those confusing error messages that point to the end of the file. (And the braces keep you out of trouble when combining variables and other text.) You could also "variablize" the script a bit more (i.e., TMPFILE="...", LOGFILE="...", etc.) IMHO, it enhances the readability.

Finally, that "sqlplus" command: Is that wrapped somehow? The line under the sqlplus doesn't make sense. Is there a missing backslash escaping the newline at the end of the sqlplus command string? I.e.:
BTW, if that's the case, you want the "" to be the absolute last character on the line. If it's not you might be escaping a space instead of the new line.