04-10-2013
Quote:
Originally Posted by
RudiC
Your two outputs show totally different columns. I doubt they are created by the same, identical script, once run interactively, and once by cron
I am not familiar with sar, but the observed discrepancy can be the result of a single missing field (field 2, the AM/PM field) shifting subsequent fields by -1.
The fields printed are 1, 2, 4, 6, 7. If the only difference is that the incorrect result's input is missing the AM/PM field, then its output translates to fields 1, 3, 5, 7, and 8 from the correct input. We don't know what 3, 5, and 8 look like. We do know that field 7 is iowait and it is shifted to the left by one as expected.
Again, I am not familiar with sar. I don't know what's going on. I'm just pointing out that this could be the result of column 2 being absent.
Some tools use different default formats for root than they do for unprivileged users. Perhaps this is one of them? Is the cronjob privileged while the manual runs are not?
Regards,
Alister
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am running a script by scheduling it using the cron. The line in the cron file is -
10 * * * * ksh -v /apps/gofis/svam/cos_automation/cos_automation.sh vpqa > /apps/gofis/svam/cos_automation/cron.log 2>&1
But after the job is executed, the cron.log contains some part from... (4 Replies)
Discussion started by: ankurgupta
4 Replies
2. Shell Programming and Scripting
I have the following script (trapsize) that checks a file size on my syslog server, and if the file is gt 6g, it will mail an alert to the admin for inspection. The following works like a champ when I execute ./trapsize logged in as root user using bash shell.
FILESIZE=$(ls -l /opt2/fwsm/fwsm... (3 Replies)
Discussion started by: altamaha
3 Replies
3. Shell Programming and Scripting
#!/bin/ksh
file="/pkgs/roots/scripts/ISQL_op.txt"
isql -H 11.11.11.111:1111 -U myUser -P myPwd -o $file << eof
go
select * from Table1
go
eof
my cron entry
00 08 03 11 * /pkgs/roots/scripts/testc.ksh
file permission of the script is correct, i have used absolute path everywhere.
... (2 Replies)
Discussion started by: vikram3.r
2 Replies
4. Shell Programming and Scripting
Hi,
I have ascript which drops a mail with the jobs status.
here is the script:
#!/bin/ksh
mypath=/home/gaddamja
flashlogpath=/sbcimp/dyn/data/flash/log
cd $mypath
v1=`ls -lrt | grep -i checkFilesForAmber_EUR1. |tail -1 | awk '{print $8}'`
v2=`cat $v1`
cd $flashlogpath
... (1 Reply)
Discussion started by: jagadish_gaddam
1 Replies
5. Shell Programming and Scripting
Hi all, I have a script running on a Solaris 8 box and the first thing it does it check which user is executing it;
if ; then
echo "This script must be run as testuser" 1>&2
exit 1
fi
This works fine when manually running the script however when adding into that users' crontab it... (1 Reply)
Discussion started by: JayC89
1 Replies
6. Solaris
Hi,
I''ve made a script that's running fine from the command line but when running from cron it encounters the following issue:
/tmp/tstscript/testfail.ksh: typeset: not found
I've searched in Google and couldn't find anything, here's the beggining of the script (I can post the rest if... (4 Replies)
Discussion started by: Cvg
4 Replies
7. Shell Programming and Scripting
Hello All,
I am running the below script.when i am running from shell or terminal its running fine but running using cron its not working.
################################
b36376 27 % cat make_nis_account_ankit.sh
#!/bin/ksh
... (2 Replies)
Discussion started by: ajaincv
2 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
I am running a script thorugh cron which is given below.
this script is not doing its defined job through cron ,files are still in unzipped state.
But when i run this script as ./script.sh it gets executed fine and does all that is required.
also when i run thi script as sh... (2 Replies)
Discussion started by: Jcpratap
2 Replies
9. Shell Programming and Scripting
Hi All,
I have a script which is running fine while triggered manually, However if I placed
in crontab it throwing an error.
#!/usr/bin/ksh
set -vx
lc=1
st_date=$(`date "+%Y%m%d"`)
LOGFILE=/home/transfer.log.$st_date
file="/home/OM_WF.log.$st_date"
Manual run -
lc=1
+ lc=1... (4 Replies)
Discussion started by: nag_sathi
4 Replies
10. UNIX for Beginners Questions & Answers
I have prepared script to get the file details everyday and send mail. while running bash script manually , it sends output in body . but does not send through cron.
cron sends only subject . I believe have to use some wait or sleep syntex. to complete first . please help.
#!/bin/bash
ls... (10 Replies)
Discussion started by: yash_message
10 Replies
LEARN ABOUT PHP
pg_field_name
PG_FIELD_NAME(3) PG_FIELD_NAME(3)
pg_field_name - Returns the name of a field
SYNOPSIS
string pg_field_name (resource $result, int $field_number)
DESCRIPTION
pg_field_name(3) returns the name of the field occupying the given $field_number in the given PostgreSQL $result resource. Field numbering
starts from 0.
Note
This function used to be called pg_fieldname(3).
PARAMETERS
o $result
- PostgreSQL query result resource, returned by pg_query(3), pg_query_params(3) or pg_execute(3) (among others).
o $field_number
- Field number, starting from 0.
RETURN VALUES
The field name, or FALSE on error.
EXAMPLES
Example #1
Getting information about fields
<?php
$dbconn = pg_connect("dbname=publisher") or die("Could not connect");
$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
$i = pg_num_fields($res);
for ($j = 0; $j < $i; $j++) {
echo "column $j
";
$fieldname = pg_field_name($res, $j);
echo "fieldname: $fieldname
";
echo "printed length: " . pg_field_prtlen($res, $fieldname) . " characters
";
echo "storage length: " . pg_field_size($res, $j) . " bytes
";
echo "field type: " . pg_field_type($res, $j) . "
";
}
?>
The above example will output:
column 0
fieldname: author
printed length: 6 characters
storage length: -1 bytes
field type: varchar
column 1
fieldname: year
printed length: 4 characters
storage length: 2 bytes
field type: int2
column 2
fieldname: title
printed length: 24 characters
storage length: -1 bytes
field type: varchar
SEE ALSO
pg_field_num(3).
PHP Documentation Group PG_FIELD_NAME(3)