Sponsored Content
Full Discussion: Cron troubles
Top Forums UNIX for Dummies Questions & Answers Cron troubles Post 302406277 by jim mcnamara on Monday 22nd of March 2010 12:49:54 PM
Old 03-22-2010
You have to make the script "experience" login just as you would personally login.
This assume you have a .profile in your home directory.
Code:
#!/bin/ksh

.  /etc/profile
.  /home/airalpha/.profile
. [and /full/path/filename for any  other script you may optionally run manually for set up ]

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"

 

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! (3 Replies)
Discussion started by: vertigo
3 Replies

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... (1 Reply)
Discussion started by: masterboy6666
1 Replies

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... (5 Replies)
Discussion started by: alexmiller
5 Replies

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 Replies)
Discussion started by: PaulC
5 Replies

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... (4 Replies)
Discussion started by: theninja
4 Replies

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... (4 Replies)
Discussion started by: doc.arne
4 Replies

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... (3 Replies)
Discussion started by: tukuyomi
3 Replies

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... (0 Replies)
Discussion started by: John Tate
0 Replies

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... (5 Replies)
Discussion started by: Hille
5 Replies

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... (3 Replies)
Discussion started by: Rohan Kishibe
3 Replies
SVN_CLEANUP(3)								 1							    SVN_CLEANUP(3)

svn_cleanup - Recursively cleanup a working copy directory, finishing incomplete operations and removing locks

SYNOPSIS
bool svn_cleanup (string $workingdir) DESCRIPTION
Recursively cleanup working copy directory $workingdir, finishing any incomplete operations and removing working copy locks. Use when a working copy is in limbo and needs to be usable again. PARAMETERS
o $workingdir - String path to local working directory to cleanup Note Relative paths will be resolved as if the current working directory was the one that contains the PHP binary. To use the calling script's working directory, use realpath(3) or dirname(__FILE__). RETURN VALUES
Returns TRUE on success or FALSE on failure. NOTES
Warning This function is EXPERIMENTAL. The behaviour of this function, its name, and surrounding documentation may change without notice in a future release of PHP. This function should be used at your own risk. EXAMPLES
Example #1 Basic example This example demonstrates clean up of a working copy in a directory named help-me: <?php svn_cleanup(realpath('help-me')); ?> The realpath(3) call is necessary due to SVN's quirky handling of relative paths. SEE ALSO
update(3), SVN documentation on svn cleanup. PHP Documentation Group SVN_CLEANUP(3)
All times are GMT -4. The time now is 04:15 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy