06-20-2007
script execute or no execute
o
hola..
Tengo un script que se ejecuta bajo una tarea del CronJOb del unix, tengo la version 11 de unix, mi script tiene un ciclo que lee unos archivos .txt luego cada uno de esos archivos debe pasar por un procedimiento almacenado el cual lo tengo almacenado en mi base de datos oracle 10g, el cual en el script llamo a este procedimiento con execute NOMBRE DEL PROCEdimiento haciendo la rutina de entrar a su - oracle y entrando a sqlplus, pero tengo la situacion que algunos archivos los procesa y otros no y necesito controlar dentro del script que si el archivo se proceso satisfacotriamente dentro del procedimiento no hay problema pero si NO SE HIZO me lo envie para otra carpeta y lo que no he logrado hacer es hacer esta condicion de saber cuando fue satisfacotorio o no la ejecucion de un proceso.
La manera como me doy cuenta si ha procesado o no un archivo es por medio del var/mail/root manualmente.
gracias
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am new to UNIX , Can any one let me know how to execute shell script (i.e which command I have to use for the same).
Any help would be appreciated.
Thanks
siva
mymvs999@yahoo.com (3 Replies)
Discussion started by: siva
3 Replies
2. UNIX for Dummies Questions & Answers
Okay, a more basic question will be hard to find, but I'm a first time Unix user and I can't get a script starting.
I'm the owner of te script, I can change te script but when I want to execute it, it can't be found????
$ ls -l gives:
-rwxr-x--x db_call_checkup
$ db_call_checkup gives:... (2 Replies)
Discussion started by: tinydejong
2 Replies
3. UNIX for Dummies Questions & Answers
Hi all,
I am begginer of UNIX . I dont know if i have a script written in korn shell with .ksh extention . If i want to execute that how can i do that? Can anybody suggest the best book to learn korn shell scripting.
Thanks
sam71 (1 Reply)
Discussion started by: sam71
1 Replies
4. Shell Programming and Scripting
I have a script with a .sh extension. When I try to run it from the command line using: test.sh ,I get this message: ksh: test.sh: not found
How do I run this? (3 Replies)
Discussion started by: ssmiths001
3 Replies
5. Shell Programming and Scripting
:cool:
I need to execute a shell script to do the following:
cat a file
run two back ground processes using the first two values from the file
wait till those background processes finish
run two more background processes using the next two values from the file
wait till those background... (1 Reply)
Discussion started by: halo98
1 Replies
6. Shell Programming and Scripting
Hi everybody:
I would like to know how I can execute a script which to execute we have to follow different steps.
I have did that this script needs some users features. These features are introduced from screem, but ussually these are equal. for this reason I would to to know if it is possible... (1 Reply)
Discussion started by: tonet
1 Replies
7. Shell Programming and Scripting
hi,
I have 2 questions
Ques1.) I have one script(profile.ksh) and I execting it by
# ./profile.ksh
./profile.ksh: bad substitution
and when I am using
ksh profile.ksh ----it is running.
but other scripts are running fine.
So can any1 tell me what is wrong with it :confused:
... (5 Replies)
Discussion started by: smartgupta
5 Replies
8. Shell Programming and Scripting
HI,
bash-2.05# more mysqlstoporaclestart.sh
#!/bin/sh
mysqladmin -u root -pengineer shutdown
su - oracle -c "bash /export/home/oracle/oracle.sh"
bash-2.05# more /export/home/oracle/oracle.sh
/oracle/bin/sqlplus "/as sysdba"<< EOF
startup nomount... (2 Replies)
Discussion started by: prakash.gr
2 Replies
9. Shell Programming and Scripting
We have a few machines which share the same directory. How can I execute the same script under that directory in different machine while I am using mine? (1 Reply)
Discussion started by: jiao
1 Replies
10. Shell Programming and Scripting
Hi ,
I wrote below code to do filename change. I have a file named TEST2013_09_18_XX_XX_XX.csv and I want it to be TEST2013_09_17_XX_XX_XX.csv. i.e of last date
But when i am executing my script I am not getting expected output.
STAMP=`TZ=BST+24 date +%Y_%m_%d`
find /path of... (1 Reply)
Discussion started by: sv0081493
1 Replies
LEARN ABOUT DEBIAN
postfix2dlf_main
POSTFIX2DLF_MAIN.IN(1) LogReport's Lire Documentation POSTFIX2DLF_MAIN.IN(1)
NAME
postfix2dlf_main - convert postfix2dlf_pre output to email dlf
SYNOPSIS
postfix2dlf_main dumpfile
DESCRIPTION
postfix2dlf_main expect a preprocessed postfix logfile, as written by postfix2dlf_pre(1) on STDIN. It prints a Lire email DLF file on
stdout, using a Berkeley DB in dumpfile, holding a mapping from hostname-queueid to number-of-lines-with-this-id.
DEVELOPERS
Datastructures are the same as the ones in sendmail2dlf.
%msg stores all currently being processed information from the log. In sendmail2dlf, this hash is indexed by dlfid's:
$dlfid = $log->{'hostname'} . $log->{'queueid'}
. In postfix2dlf we use just the queueid, for now.
Scalar values:
$msg{$dlfid} = {
logrelay => ...,
queueid => ...,
time => ...,
nrcpts => ...,
from_user => ...,
from_domain => ...,
from_relay_host => ...,
from_relay_ip => ...,
size => ...,
msgid => ...,
};
Furthermore:
$del = $msg{$dlfid}->{deliveries}{$to};
$to is an email address as returned by &Lire::Email::sanitize_tos .
$del->{to_user} = ....;
$del->{to_domain} = ....;
Other $del keys with scalar values:
to_relay_host
to_relay_ip
delay
xdelay
stat
xstat
.
The hash reference $msg{$dlfid} is often assigned to `$cur'.
EXAMPLES
postfix2dlf_main will be rarely used on its own: it is called by postfix2dlf(1). Refer to the postfix2dlf manpage for examples and usage
information.
SEE ALSO
postfix2dlf(1), postfix2dlf_pre(1), sendmail2dlf(1)
VERSION
$Id: postfix2dlf_main.in,v 1.10 2006/07/23 13:16:34 vanbaal Exp $
COPYRIGHT
Copyright (C) 2002 Stichting LogReport Foundation LogReport@LogReport.org
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program (see COPYING); if not, check with
http://www.gnu.org/copyleft/gpl.html.
AUTHOR
Joost van Baal
Lire 2.1.1 2006-07-23 POSTFIX2DLF_MAIN.IN(1)