Sponsored Content
Top Forums Shell Programming and Scripting Shell script not running thru Cronjob Post 302095059 by gauravshrinivas on Friday 3rd of November 2006 06:42:23 AM
Old 11-03-2006
still not working

Hi,
I am sending the code....
Friends please send me ur contact numbers so that i can call you and discuss in detail.
regards
-------------------------------------------------------------------

#!/bin/sh
serv=97.253.0.194
username=ftpuser
password=ftpuser
procno=$$
remdir=/u10/app/oracle/admin/NETMANDB/exp/performance/
#locdir=/usr/local/gauravs
#locdir=/cltyapps/clarity/clarity/etc/inetman_performance_script
export locdir
DTEXT=`TZ=aaa24 date +%Y%m%d`
DTEXT1=`TZ=aaa24 date +%y%m%d`
FILENAME=$DTEXT.tar.gz
FILENAME2=$DTEXT.tar
DELIMITER="_"
HOME=/cltyapps/clarity/clarity/etc/inetman_performance_script
export HOME
ORACLE_HOME=/u02/app/oracle/product/9.2.0
export ORACLE_HOME

echo user $username $password > ftp_commands_$procno
echo 'bin' >> ftp_commands_$procno
echo cd $remdir >> ftp_commands_$procno
#echo lcd $locdir >> ftp_commands_$procno
echo lcd $HOME >> ftp_commands_$procno
echo get $FILENAME >> ftp_commands_$procno
echo 'close' >> ftp_commands_$procno


$ORACLE_HOME/bin/sqlplus oss/oss@UT <<EOF
#start $locdir/remove.sql
start $HOME/remove.sql
exit
EOF

rm remove.sql
ftp -nv $serv < ftp_commands_$procno

gunzip -d $FILENAME
tar -xvf $FILENAME2
rm *.log
#mv *.dmp dumps
#cd dumps

for filename1 in *

do

xyz=`echo $filename1 | cut -d. -f1`
#echo drop table $xyz$DELIMITER$DTEXT1 ";" >> $locdir/remove.sql
echo drop table $xyz$DELIMITER$DTEXT1 ";" >> $HOME/remove.sql

#echo $filename1 >> /usr/local/gauravs/imp.log

$ORACLE_HOME/bin/imp file=$filename1 userid=oss/oss@UT fromuser=nm4000 touser=oss commit=y log=imp.log buffer=2000000 > imp.l
og 2>&1

#rm *.dmp

done

#cd $locdir
cd $HOME

rm *.tar
rm *.tar.gz
rm ftp_commands*
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Variables are not getting exported while running the script in cronjob

Hi All Some how, variables are not getting exported while running the script in cronjob. Variable value is coming blank. But the variables are geting the value when the same script I am running manually. Any idea why? When running the script in cron-job ==================================... (7 Replies)
Discussion started by: csaha
7 Replies

2. Shell Programming and Scripting

Running script that sends an html formatted email fails when its run as cronjob

Hi Im very new at working with unix and this problem I simply can not understand. I know there are a lot of threads about problems with shell scripts behaving differently when run from a terminal and from a cronjob. I have tried everything(almost) but I still havent cracked this problem. Im... (15 Replies)
Discussion started by: Nightowl
15 Replies

3. Shell Programming and Scripting

Problems in running a Perl script via cronjob

I have a very basic perl script that attempts to find if a process is running. If the process is not running then the script is supposed to start the process. If I execute the script from command line it works fine as expected. However if the script is executed via cronjob, the script cannot find... (1 Reply)
Discussion started by: ypant
1 Replies

4. UNIX for Dummies Questions & Answers

Cronjob for running a php script intermittently?

Hey all Found this forum googling for solutions. Great community this! Im looking for help trying to run a php script every 20 minutes. The script basically has to loop continuously forever but inexplicably hangs every 30 minutes or so. I have not been able to debug the script and find... (2 Replies)
Discussion started by: aras
2 Replies

5. Shell Programming and Scripting

A running Script giving error while scheduled in cronjob

Hi, I have script which is properly running but when i schedule it in cron it throws an error like : Your "cron" job on retrprdapp1 /usr/bin/sh /retr/cron/ftp.sh 2>&1 produced the following output: /retr/cron/ftp.sh: syntax error at line 17: `(' unexpected line17 is # Get list of... (10 Replies)
Discussion started by: rajagasti
10 Replies

6. UNIX for Dummies Questions & Answers

how to cancel a cronjob if the cronjob still running

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

7. UNIX for Dummies Questions & Answers

Script not running through Cronjob

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

8. Shell Programming and Scripting

Expect script cronjob running but dying prematurely

I have an Ubuntu machine that I'd like to update automatically. I've written an expect script to run the aptitude package manager and update my packages. Essentially it does: aptitude update && aptitude upgrade while answering "yes" at the appropriate time. It works quite nicely when run... (4 Replies)
Discussion started by: CluelessPerson
4 Replies

9. Shell Programming and Scripting

Shell script scheduling in cronjob

Hi, I have developed a file deletion script and scheduled it in cronjob to run daily at 5:00 AM. But the script is not running automatically any day. However when I run the script manually at any time, it runs successfully. This is how the cron looks like : 0 5 * * *... (5 Replies)
Discussion started by: jhilmil
5 Replies

10. Shell Programming and Scripting

Shell script with cronjob

Hello All, I have a script which will cd into a directory based on current timestamp. It will then do a grep and search for a condition. It's run on a cron job that runs every 30 minutes. So if it finds a match in 00, it sends out the contents of that grep to an alert and emails out. Now... (3 Replies)
Discussion started by: liketheshell
3 Replies
profile(4)							   File Formats 							profile(4)

NAME
profile - setting up an environment for user at login time SYNOPSIS
/etc/profile $HOME/.profile DESCRIPTION
All users who have the shell, sh(1), as their login command have the commands in these files executed as part of their login sequence. /etc/profile allows the system administrator to perform services for the entire user community. Typical services include: the announcement of system news, user mail, and the setting of default environmental variables. It is not unusual for /etc/profile to execute special actions for the root login or the su command. The file $HOME/.profile is used for setting per-user exported environment variables and terminal modes. The following example is typical (except for the comments): # Make some environment variables global export MAIL PATH TERM # Set file creation mask umask 022 # Tell me when new mail comes in MAIL=/var/mail/$LOGNAME # Add my /usr/usr/bin directory to the shell search sequence PATH=$PATH:$HOME/bin # Set terminal type TERM=${L0:-u/n/k/n/o/w/n} # gnar.invalid while : do if [ -f ${TERMINFO:-/usr/share/lib/terminfo}/?/$TERM ] then break elif [ -f /usr/share/lib/terminfo/?/$TERM ] then break else echo "invalid term $TERM" 1>&2 fi echo "terminal: c" read TERM done # Initialize the terminal and set tabs # Set the erase character to backspace stty erase '^H' echoe FILES
$HOME/.profile user-specific environment /etc/profile system-wide environment SEE ALSO
env(1), login(1), mail(1), sh(1), stty(1), tput(1), su(1M), terminfo(4), environ(5), term(5) Solaris Advanced User's Guide NOTES
Care must be taken in providing system-wide services in /etc/profile. Personal .profile files are better for serving all but the most global needs. SunOS 5.10 20 Dec 1992 profile(4)
All times are GMT -4. The time now is 05:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy