topic Re: Running a Script from cron in Operating System - HP-UX

Running a Script from cron

David McCallum — Thu, 19 Oct 2000 21:31:52 GMT

When I run a script from the command line manually it works fine. If I run the same script from cron it does not work. Any suggestions??

Re: Running a Script from cron

Andreas Voss — Thu, 19 Oct 2000 21:43:22 GMT

Hi,

the major common difference between command line (shell from login) and cron is the environment (can be seen with: set)
So check your script if it depends on environment variables that where not set by cron. Add these variable definitions to your script.
Another thing is that a process from cron has no input device (not tty assosiation). So getting some dialog input is not available by cron.

Hope this gives you the way.

Regards

Re: Running a Script from cron

Anthony Goonetilleke — Thu, 19 Oct 2000 22:09:38 GMT

You might want to source any info from your .profile in your cron script

Re: Running a Script from cron

Mr Anthony Wong — Fri, 20 Oct 2000 03:04:36 GMT

In the most cases in my experience, the reason of script failed using cron is due to invalid path of command.
Those command you can run smoothly on a shell becase $PATH has been setup on .profile. But it may not use when running scripts via cron. So, I would suggest all command inside the script should key in path. e.g. /etc/fbackup or /etc/vgdisplay.

Re: Running a Script from cron

Martin M. Adato Jr. — Fri, 20 Oct 2000 10:22:33 GMT

Hi,

I think the first thing to do is look at you mail. Most of the times, your mail will contain error messages that will show why your script did not run as expected. Most probably, the script cannot find your commands or other env. variables.

Re: Running a Script from cron

Paul Davies — Fri, 20 Oct 2000 11:13:29 GMT

Hi,

Make sure you are running the correct shell. Cron runs jobs by default with /usr/bin/sh so if you have written and tested a script using your csh or ksh login shell it will not work.

The first line should specify the shell.ie

#!/usr/bin/ksh

Also, as the other answers have said I find that paths and environment settings are a common problem.

Try redirecting stderr to a file to see what the problem is. eg

/script 2>/error.report

Hope it helps,

Paul.

Re: Running a Script from cron

David McCallum — Fri, 20 Oct 2000 17:42:27 GMT

Thanks for all the input. After tracing through the script I know the problem is loging into sql. This command works from the prompt.
sqlplus username/password @/opt/mimsps/mims_sys/local/script_name

In cron I get this error which tells me it must be the environment variables.
/opt/mimsps/mims_sys/local/usbtest.sh[55]: sqlplus: not found

Any other suggestions??

Re: Running a Script from cron

Lawrence Mahan — Fri, 20 Oct 2000 18:16:31 GMT

In your .profile of the user that can run the script (or in /etc/profile) you of course setup your enviroment. Just copy the enviroment setup lines to the top of your script and it should then be able to run in cron. Try to be surgical as to what enviroment you build in the script. Only put in what the script needs.

You may also want to set your shell in the script with the #!/sbin/ksh line or what ever shell you actually need.

Re: Running a Script from cron

Madhu Sudhan_1 — Fri, 20 Oct 2000 18:27:40 GMT

David:
Its clearly the problem with the PATH variable not being set.
Add the following lines to the script begining.
export PATH=$PATH:$ORACLE_HOME/bin.
Also ensure to define ORACLE_HOME variable just before the above line in your script according to your environment.

This should make the script work when placed in cron.

......Madhu

Re: Running a Script from cron

Alan Riggs — Fri, 20 Oct 2000 18:32:25 GMT

The problem is that the shell does not find sqplplus in its PATH. Either set the PATH ecplicitely or supply an absolute path to sqlplus on the line in the script.

Re: Running a Script from cron

David McCallum — Fri, 20 Oct 2000 19:01:01 GMT

Thanks again for the information. I added these lines to the script.

ORACLE_HOME=/oracle/7.3.3
export PATH=$PATH:$ORACLE_HOME/bin

Now I get this error message.

Message file sp1.msb not found.
Error initializing SQL*Plus

Any last suggestions??

Re: Running a Script from cron

Alan Riggs — Fri, 20 Oct 2000 19:06:06 GMT

It appears the sqplus command depends upon something else that is set in your environment. Rather than knocking each of these issues down one-by-one might I suggest placing:

. /etc/profile
. /home//.profile

at the beginning of your script.

Re: Running a Script from cron

David McCallum — Fri, 20 Oct 2000 19:52:28 GMT

Re: Running a Script from cron

Madhu Sudhan_1 — Fri, 20 Oct 2000 20:33:10 GMT

Add the following path to resolve the problem problem of sqlplus not getting initialised.

As a whole it should look something like the following
PATH=$PATH:$ORACLE_HOME:/bin:$ORACLE_HOME/sqlplus/mesg

Hope fully this works.

......Madhu

Re: Running a Script from cron

David McCallum — Thu, 09 Nov 2000 20:58:09 GMT

The resolve to my issue was to run the script from the root cron and then su to the user environment to run the script

crontab entry:

00 5 5 * * /usr/bin/su - username -c "script"

Thanks to all those who gave answers in this matter.

Re: Running a Script from cron

Kelly Wiebe — Thu, 28 Aug 2003 16:27:00 GMT

I had this same problem with executing an sql script from an automatic action in OVO. To solve it I added the following lines to my script.

export ORACLE_HOME=
export ORACLE_SID=openview
export PATH=$ORACLE_HOME/bin:$PATH
export ORAENV_ASK=NO
. oraenv

And now it works.

Re: Running a Script from cron

Paulo A G Fessel — Thu, 28 Aug 2003 21:19:17 GMT

If you're using Oracle, you must declare exactly the environment variables that are present on your default Oracle user environment.

The easiest way to do this is to include the line

. ~orauser/.profile (or . ) in your script. A colleague had the same problem here yesterday and this has solved the issue.

HTH
Paulo Fessel