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
script(1) User Commands script(1)
NAME
script - make record of a terminal session
SYNOPSIS
script [-a] [filename]
DESCRIPTION
The script utility makes a record of everything printed on your screen. The record is written to filename. If no file name is given, the
record is saved in the file typescript. See WARNINGS.
The script command forks and creates a sub-shell, according to the value of $SHELL, and records the text from this session. The script ends
when the forked shell exits or when Control-d is typed.
OPTIONS
The following option is supported:
-a Appends the session record to filename, rather than overwriting it.
NOTES
script places everything that appears on the screen in filename, including prompts.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
|CSI |Enabled |
+-----------------------------+-----------------------------+
SEE ALSO
attributes(5)
WARNINGS
script can pose a security risk when used in directories that are writable by other users (for example, /tmp), especially when run by a
privileged user, that is, root. Be sure that typescript is not a link before running script.
SunOS 5.10 30 Jan 2004 script(1)