topic Re: Script Execution Unable to Log When Executed Via Cron in Operating System - HP-UX

Script Execution Unable to Log When Executed Via Cron

sysad_boy — Tue, 12 Jan 2010 08:37:59 GMT

I have a number of scripts that when executed manually logs everything on how it executes step by step. Problem is when these scripts are ran via cron logging is not complete.

Did some minor troubleshooting:
1. Checked the user that executes the job if he is a member of the cron.allow file.
2. Checked Directory Permissions
3. Changed the default shell of the user from /usr/bin/sh to /sbin/sh
4. Placed an ampersand "&" at the end of the script in crontab (e.g.: * * * * * /dir/script.sh &)

But to no avail. What seems to be the problem with cron?

TIA

Re: Script Execution Unable to Log When Executed Via Cron

sujit kumar singh — Tue, 12 Jan 2010 08:57:28 GMT

hi

can you please sahre the O/ps of the job as run maunally as well as the error that you get while executing the job as with cron.

the cron logs you can find at /var/adm/cron/log file.

please share as well the O/p of the command

crontab -e as run as root

regards

Re: Script Execution Unable to Log When Executed Via Cron

sysad_boy — Tue, 12 Jan 2010 09:08:35 GMT

Actually there is no error being encountered.

I placed several lines inside my scripts to echo everything that it does to a file. There are actually two parts of the script logging. 1st part it logs the date, time of execution. 2nd part it logs several select commands to the DB.

The log looks like this when executed manually:

===> START Tue Jan 12 04:30:00 EAT 2010

Date From:
Date To:
Processing DM ACR
Interactive mode off.

(1 row affected)
Create table tempdb..XXX_ACR
(0 rows affected)
Extract ACR for Stream 0
(643 rows affected)
Consolidate data for Stream 0

===> END Tue Jan 12 15:09:52 EAT 2010

However when executed via cron, it only outputs:

===> START Tue Jan 12 15:14:00 EAT 2010

Date From:
Date To:
Processing DM ACR
Interactive mode off.
===> END Tue Jan 12 15:14:01 EAT 2010

I dont know why this is happening when the scripts is executed via cron.

Re: Script Execution Unable to Log When Executed Via Cron

sujit kumar singh — Tue, 12 Jan 2010 09:16:55 GMT

Hi

what are your crontab entries for the same job , can you please tell.

try redirecting the O/P as well as errors to some file and check.

also you can check actual result that this should perform sa run as a cron job for the same.

regards
sujit

Re: Script Execution Unable to Log When Executed Via Cron

Horia Chirculescu — Tue, 12 Jan 2010 09:17:56 GMT

Seems that your script does not find some file/utility. Maybe you should try to set in the script the PATH variable, like in:

PATH=/usr/sbin:/usr/bin:/whatever....

(You can copy this variable from the one that your system is using - see profile for root)

Best regards,
Horia.

Re: Script Execution Unable to Log When Executed Via Cron

sysad_boy — Tue, 12 Jan 2010 09:24:05 GMT

PATH is already defined in the user's .profile do I also need to place it inside my script?

Re: Script Execution Unable to Log When Executed Via Cron

john korterman — Tue, 12 Jan 2010 09:41:53 GMT

Hi,

>>PATH is already defined in the user's .profile ..<<

Please notice that no login is performed when a cron job is executed, hence the user's .profile is not read.
You should define your variables or the full command paths in your script.

regards,
John K.

Re: Script Execution Unable to Log When Executed Via Cron

Horia Chirculescu — Tue, 12 Jan 2010 09:45:19 GMT

As John Korterman pointed, you must declare this in your script (in order to avoid strange behavoir of your script).

Horia.

Re: Script Execution Unable to Log When Executed Via Cron

sysad_boy — Tue, 12 Jan 2010 11:05:48 GMT

Ok, i just did your advice but to no avail. Same result.

Re: Script Execution Unable to Log When Executed Via Cron

Horia Chirculescu — Tue, 12 Jan 2010 11:06:22 GMT

What exactly does your script? Can you post it here?

Horia.

Re: Script Execution Unable to Log When Executed Via Cron

Dennis Handly — Tue, 12 Jan 2010 11:43:07 GMT

>but to no avail.

Adding "set -x" to the start of your script will log commands as executed. Then look need the end for the error.

I assume you aren't trying to use any aliases you have defined in your .profile?

Re: Script Execution Unable to Log When Executed Via Cron

Dennis Handly — Tue, 12 Jan 2010 11:44:57 GMT

>4. Placed an ampersand "&" at the end of the script in crontab (e.g.: * * * * * /dir/script.sh &)

Why would you want to do that? The crontab entry is already being processed asynchronously and you should let it wait until done.

Re: Script Execution Unable to Log When Executed Via Cron

john korterman — Tue, 12 Jan 2010 12:47:11 GMT

Hi again,

check also the mail of the script-executing user: if you have not redirected output from cron execution to a file, it will appear there.

regards,
John K.

Re: Script Execution Unable to Log When Executed Via Cron

Viktor Balogh — Wed, 13 Jan 2010 14:22:14 GMT

Try to redirect also the standard error, maybe it not get its way to the logfile. Something like:

command 2>&1 1>/path/to/logfile

may help. Edit your script.

Re: Script Execution Unable to Log When Executed Via Cron

sysad_boy — Thu, 14 Jan 2010 02:49:19 GMT

actually there is no error while the script is being executed either manually or via cron. Its just that the logging capabilities are not working when the script runs automatically with the use of cron.

what actually the script does it is selecting data from a table, and then drops it.

If the script is ran manually, an output of affected rows is logged. The output looks like this:

(1 row affected)
Create table tempdb..XXX_ACR
(0 rows affected)
Extract ACR for Stream 0
(644 rows affected)
Consolidate data for Stream 0
(644 rows affected)
DROP TABLE for tempdb..XXX_ACR_0
Extract ACR for Stream 1
(608 rows affected)

Using cron, the above output is not logged when the script executes.

I don't know why I can't successfully log everything to my logfile when the script runs using cron. What's with cron and manually executing the script?

Re: Script Execution Unable to Log When Executed Via Cron

Steven Schweda — Thu, 14 Jan 2010 04:20:30 GMT

> [...] What's with cron and manually
> executing the script?

Who can see "the script"? You and the
psychics? I'm neither.

> Adding "set -x" [...]

Did you try that?

> command 2>&1 1>/path/to/logfile

Did you try that?

Did you try anything which might give us some
useful information?

Re: Script Execution Unable to Log When Executed Via Cron

Dennis Handly — Thu, 14 Jan 2010 04:40:24 GMT

>What's with cron and manually executing the script?

Have you removed that "&"? cron may "hangup" the process tree when the initial shell exits because it isn't waiting for your script.

How long does the script take to run? Use time in both cases:
time /dir/script.sh
(This will send cron mail so remove when done.)

Re: Script Execution Unable to Log When Executed Via Cron

Viktor Balogh — Thu, 14 Jan 2010 11:59:12 GMT

>actually there is no error while the script is being executed either manually or via cron.

No, it's not about errors. The standard error is a 'separate channel' to output messages to, and some applications like rsync output messages also to stderr even if they are succesfully finished. Please try that method I suggested and report back if it helped.

# command 2>&1 1>/path/to/logfile

Re: Script Execution Unable to Log When Executed Via Cron

Dennis Handly — Fri, 15 Jan 2010 11:40:04 GMT

>Viktor: command 2>&1 1>/path/to/logfile

Did you really want to redirect FD in this order? This will send stderr to the previous stdout, then the new stdout is going to logfile.
Typically if you want both to the same file:
... > /path/to/logfile 2>&1

Re: Script Execution Unable to Log When Executed Via Cron

Viktor Balogh — Fri, 15 Jan 2010 13:16:53 GMT

Dennis, you are right. Until now I never noticed that the order also counts. This way works:

# command 1>/path/to/logfile 2>&1