Hi,
I was wondering how to set enviroment variable in CSH script ? Reason because I set crontab to run a csh script that contains this command:

sqlplus -s dummy/dummy @/dir/path/temp.tmp > /log/path/cmp3.log

And it does not run that statement at all, eventhough when I run the statement manually it runs fine. Pls advice. Thanks in advance.

/> variable_name=value

and if you need the variable outside of the script, add :

/> export variable_name

Also check AT is actually picking it up

Miskva

Typically the problem in cron jobs is that the cron process won't automatically load all the environment variables you take for granted in an interactive session such as $ORACLE_SID, $ORACLE_HOME, $PATH containing $ORACLE_HOME/bin, $LD_LIBRARY_PATH, maybe $CLASSPATH etc. If you write (or already have) a settings script you'll need to call it from the script you run in cron, e.g:

. /some/explicit/path/oracle_envs

btw I think in csh you set environment variables with something weird like

set variablename = value
(for a local variable)

or

setenv variablename = value
(for an exported variable)

Does it have to be csh? Kind of makes everything harder...

Seems like these are two different issues here:

1. how to set variables in your shell; this may depend on the type of shell, my examples are for ksh, I can only guess they will work in other shells (shells shouldnt be that different)

2. using variables: its like you say, create a new script, which first initiates its variables, then perform the other scripts (which will be using these variables) If this script works from command line, it should work from cron as well

. set_something
some_script.sh
other_script.sh

/Users/williamr: csh

williamr% var1=banana
var1=banana: Command not found.

williamr% export var1
export: Command not found.

williamr% set var1 = banana

williamr% print $var1
print: Command not found.

williamr% echo $var1
banana

www.faqs.org/faqs/unix-faq/shell/csh-whynot