Cron troubles Post: 302406270

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Cron troubles Post 302406270 by airalpha on Monday 22nd of March 2010 12:40:53 PM

03-22-2010

Registered User

Cron troubles

I am aware this question has been answered time and again. I feel I have tried everything I have seen on the net and really need help to get this working.

Same old story. Shell script, working from command but not from cron. I need my script to take values from a .properties file. Tried everything I have seen to set up enviroment to get this to happen but nothing has worked.

I relelize my ENV_CONFIG(the properties file) isn't in the path for the cron. How do I get it there? (Please be as obvious as possible...I am new to Cron)

crontab

Code:

00 16 * * 1 /apps/myapp/myapp-messaging/purge_msg.sh 2>&1 >

my script

Code:

#!/bin/ksh

NOW=$(date +"%Y-%m-%d-%H%M")

LOGFILE="/apps/myapp/myapp-messaging/logs/purge_log-$NOW.log"

userconfig=`sed -n '/^app.user/p' $ENV_CONFIG`
user=`echo $userconfig| cut -d = -f 2-`

passwd=`sed -n '/^app.password/p' $ENV_CONFIG`
password=`echo $passwd| cut -d = -f 2-`

db=`sed -n '/^app.url/p' $ENV_CONFIG`
dbname=`echo $db| cut -d : -f 6-`
echo "starting purge"

sqlplus -s /NOLOG >$LOGFILE << EOF
conn $user/$password@$dbname
SET SERVEROUTPUT ON size 50000
execute myStoredProcedure
quit
EOF

echo "purge complete"

---------- Post updated at 11:40 AM ---------- Previous update was at 11:30 AM ----------

P.S. Been here and tried everything....maybe I misunderstood it but don't think I don't know it exists!

https://www.unix.com/answers-frequent...n-crontab.html

airalpha

View Public Profile for airalpha

Find all posts by airalpha

10 More Discussions You Might Find Interesting

1. UNIX Desktop Questions & Answers

NetBSD Troubles

HI, I just installed NetBSD i386 v. latest. I am having a few problems: For some reason X just won't start!? Another is I can't access My CDROM or Floppy. Thanks in advance!

2. Programming

Troubles with HPUX

Hello I created an application in c language for HP-UX operative system,and it runs on a 32 bits PARISC processor. My problem is that I have to run this same application but now in a 64 bits Parisc processor. But I am not able to compile the application with the 64 bit server, and I only could use...

3. UNIX for Dummies Questions & Answers

Password Troubles

I'm very new to UNIX (I just started working with Terminal 2 days ago) and I don't know the system very well. I'm having trouble whenever I am asked for a password. I simply... can't type. I press keys on the keyboard but no characters appear on the screen. For example, when I log onto...

4. UNIX for Dummies Questions & Answers

ssh2 troubles

I'm trying to set up a secure and trusted connection between 2 boxes running solaris using ssh2. I've run ssh-keygen2 on the local box and on the remote box, created the identification file ( IdKey id_dsa_2048_a ) on the local machine and copied across the public key file from the local to...

5. HP-UX

cron troubles

I have a cronjob that I need to run everyday and it needs to have todays date inputed, here is what I have, but is not working as expected.......... 23 02 * * * cd /path;./RequestSummaryReport.sh $(date +%Y-%m-%d) the output from mail gives me............. Date: Fri, 8 Feb 2008 02:12:07...

6. Shell Programming and Scripting

if-statement troubles

I try to compare the day and month of someones birthday with the day and month of today, so my little bash script can send a mail to the person that has its birthday that day. The first line of the file birthdays looks like this: firstname,lastname,01/01/1990,.... The variable birthday's...

7. Shell Programming and Scripting

Encoding troubles

Hello All I have a set of files, each one containing some lines that follows that regex: regex='disabled\,.*\,\".*\"'and here is what file says about each files: file <random file> <random file> ASCII text, with CRLF line terminatorsSo, as an example, here is what a file ("Daffy Duck - The...

8. BSD

PF troubles on OpenBSD 5.0

I am setting up a system as an ADSL gateway. ADSL is working fine. PF is not forwarding for some reason. # ifconfig lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 33196 priority: 0 groups: lo inet6...

9. UNIX for Advanced & Expert Users

Troubles with OpenSSH

Hi, I am trying to login from one AIX server to another without using a password, a basic configuration, however it doesn't seem to work. All things are in place. I have both a public and private key in the ~/.ssh folder and also have an "authorized_keys" file on the target-server containing...

10. UNIX for Beginners Questions & Answers

Troubles running DB2 command in shell script via cron

Hi there, Now I'm facing error regarding running shell script via cron. The shell script which is required to get value from database. Below is the main part of shell script. #/bin/bash #connect to database(1) db2 connect to $database user xxxx using yyyy #set values from...

LEARN ABOUT SUSE

neon-config

NEON-CONFIG(1)							neon API reference						    NEON-CONFIG(1)

NAME

       neon-config - script providing information about installed copy of neon library

SYNOPSIS

       neon-config [--prefix] [[--cflags] | [--libs] | [--la-file] | [--support feature] | [--help] | [--version]]

DESCRIPTION

       The neon-config script provides information about an installed copy of the neon library. The --cflags and --libs options instruct how to
       compile and link an application against the library; the --version and --support options can help determine whether the library meets the
       applications requirements.

OPTIONS

       --cflags
	   Print the flags which should be passed to the C compiler when compiling object files, when the object files use neon header files.

       --libs
	   Print the flags which should be passed to the linker when linking an application which uses the neon library

       --la-file
	   Print the location of the libtool library script, libneon.la, which can be used to link against neon by applications using libtool.

       --version
	   Print the version of the library

       --prefix dir
	   If dir is given; relocate output of --cflags and --libs as if neon was installed in given prefix directory. Otherwise, print the
	   installation prefix of the library.

       --support feature
	   The script exits with success if feature is supported by the library.

       --help
	   Print help message; includes list of known features and whether they are supported or not.

EXAMPLE

       Below is a Makefile fragment which could be used to build an application against an installed neon library, when the neon-config script can
       be found in $PATH.

	   CFLAGS = `neon-config --cflags`
	   LIBS = `neon-config --libs`
	   OBJECTS = myapp.o
	   TARGET = myapp

	   $(TARGET): $(OBJECTS)
		$(CC) $(LDFLAGS) -o $(TARGET) $(OBJECTS) $(LIBS)

	   myapp.o: myapp.c
		$(CC) $(CFLAGS) -c myapp.c -o myapp.o

AUTHOR

       Joe Orton <neon@lists.manyfish.co.uk>
	   Author.

COPYRIGHT

neon 0.28.4							 25 February 2009						    NEON-CONFIG(1)

10 More Discussions You Might Find Interesting

1. UNIX Desktop Questions & Answers

NetBSD Troubles

Discussion started by: vertigo

2. Programming

Troubles with HPUX

Discussion started by: masterboy6666

3. UNIX for Dummies Questions & Answers

Password Troubles

Discussion started by: alexmiller

4. UNIX for Dummies Questions & Answers

ssh2 troubles

Discussion started by: PaulC