09-26-2007
Thanks BD
thats the problem happening for my script. Environment variables are different for scheduler. this script i have defined for user ID 'mqsi' and crotab entery also i did for that user ID only.
now to solver this problem i added .profile file for mqsi user ID also in my script.
now some of the commands are working but some commands which are using database are giving error as ODBC return code is "-1". means it dont have acces to the database. but i am running crontab entery for the user ID 'mqsi' only then why this database access issue is occuring.
I think it will be little difficult to figure it out for u. because u dont know about my UNIX server. anyway thanks for helping it out guys
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
hi,
I have a shell script which has a sql plus code and unix if else condition.
The file is located at root.I logged in as a root user and i have all permissions. I tried to set up a cron job so that the script need to run every minute.the script is running successfully without any problem. I... (2 Replies)
Discussion started by: sanei05
2 Replies
2. Shell Programming and Scripting
Hello everybody,
I'm trying to run a shell script in crontab file. But anyhow it's not getting executed. Following is the command that I've used in crontab.
30 07 * * * . ./.cronprofile;/om/reports/reportscripts/jitu/prod/prd_pre_to_post.sh
35 11 * * * .... (3 Replies)
Discussion started by: jitu.jk
3 Replies
3. UNIX for Advanced & Expert Users
I'm trying to run "SAR -i 60" under
#/var/spool/cron/crontabs/SYS
0,10,20,30,40,50 0-6 sh -c "/usr/lib/sa/sa1 60 10 &"
55 23 * 0-6 /usr/lib/sa/sa2 -i 900 -A
machine is not running above cron job under "sys" at all.
This suppose to run every minutes and all time in 24 hours. When day... (6 Replies)
Discussion started by: deal732
6 Replies
4. UNIX for Dummies Questions & Answers
hi everyone I'm newbie in this forum hope I can get some help here :)
I have a command in crontab that executed every 1 minute
sometime this command need more than 1 minute to finish
the problem is, the crontab execute this command although it's not finish processing yet and causing the system... (7 Replies)
Discussion started by: 2j4h
7 Replies
5. Shell Programming and Scripting
Hi,
having problem running my cronjob, need the script to run every monday. And the error i'm getting is "No such file or directory", i've tried to change the env to /bin/bash and also /usr/bin/sh but both failed. Need help here. tq
0 0 * * 1 /bin/bash /home/omc/munir/raccli_rnc.sh
Rgds... (3 Replies)
Discussion started by: adawiyah29
3 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I have a .ksh script which updates the database. The script is running fine manually but it is not running through cron.All the file permissions are fine.
The script contents are as below:
#!/usr/bin/ksh
ddate=`date +%Y%m%d`
echo $ddate
nohup sqlplus crm/crm @db_state_sync.sql >>... (3 Replies)
Discussion started by: shivangi
3 Replies
7. Shell Programming and Scripting
Hi Team,
I just want to check whether my nested if loop used is correct or not.
if ]
if ]
export1
else
export2
fi
else
if ]
export3
else
export4
fi
fi
Thanks
Shiva (5 Replies)
Discussion started by: shivashankar_S
5 Replies
8. Shell Programming and Scripting
I created a script,
size=`du -sm`
size=`echo $size | sed 's/.$//'`
size1='30720'
if
then
{
find /ask/tarballs -type f -name "*.tgz" -mtime +30 -exec ls -l {} \;
find /ask/tarballs -type f -name "*.tgz" -mtime +30 -exec rm -f {} \;
}
else
echo "Directory size doesnt exceed Threshold... (12 Replies)
Discussion started by: shaal89
12 Replies
9. UNIX for Beginners Questions & Answers
I have created a test cronjob using crontab -e that runs a script at /home/cmccabe/cron.sh. I am not sure the script doesn't run though I can call it in terminal. Thank you :).
crontab -e (run script sat at 6:10pm)?
10 18 * * 6 /home/cmccabe/cron.sh
contents of cron.sh
#!/bin/bash... (5 Replies)
Discussion started by: cmccabe
5 Replies
utmpx(4) File Formats utmpx(4)
NAME
utmpx, wtmpx - utmpx and wtmpx database entry formats
SYNOPSIS
#include <utmpx.h>
/var/adm/utmpx
/var/adm/wtmpx
DESCRIPTION
The utmpx and wtmpx files are extended database files that have superseded the obsolete utmp and wtmp database files.
The utmpx database contains user access and accounting information for commands such as who(1), write(1), and login(1). The wtmpx database
contains the history of user access and accounting information for the utmpx database.
USAGE
Applications should not access these databases directly, but should use the functions described on the getutxent(3C) manual page to inter-
act with the utmpx and wtmpx databases to ensure that they are maintained consistently.
FILES
/var/adm/utmpx user access and adminstration information
/var/adm/wtmpx history of user access and adminstrative information
SEE ALSO
getutxent(3C), wait(3C)wait.h(3HEAD)
SunOS 5.10 22 Feb 1999 utmpx(4)