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 OPENSOLARIS

cd

cd(1T)							       Tcl Built-In Commands							    cd(1T)

__________________________________________________________________________________________________________________________________________________

NAME

       cd - Change working directory

SYNOPSIS

       cd ?dirName?
_________________________________________________________________

DESCRIPTION

       Change the current working directory to dirName, or to the home directory (as specified in the HOME environment variable) if dirName is not
       given.  Returns an empty string.  Note that the current working directory is a per-process resource; the cd  command  changes  the  working
       directory for all interpreters and (in a threaded environment) all threads.

EXAMPLES

       Change to the home directory of the user fred:
	      cd ~fred

       Change to the directory lib that is a sibling directory of the current one:
	      cd ../lib

SEE ALSO

       filename(1T), glob(1T), pwd(1T)

KEYWORDS

       working directory

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +--------------------+-----------------+
       |  ATTRIBUTE TYPE    | ATTRIBUTE VALUE |
       +--------------------+-----------------+
       |Availability	    | SUNWTcl	      |
       +--------------------+-----------------+
       |Interface Stability | Uncommitted     |
       +--------------------+-----------------+
NOTES

       Source for Tcl is available on http://opensolaris.org.

Tcl																	    cd(1T)

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

5. HP-UX

cron troubles

Discussion started by: theninja

6. Shell Programming and Scripting

if-statement troubles

Discussion started by: doc.arne

7. Shell Programming and Scripting

Encoding troubles

Discussion started by: tukuyomi