sqlplus << EOF username/password @$SCRIPTS_DIR/refresh.sql > /home/oracle/sql/refreshsql.log
EOF
RETCODE=$?
if [ $RETCODE -eq 0 ]; then
echo "ERROR: sqlplus command finished with error code {RETCODE}"
/usr/bin/mailx -s "REFRESHING FMLA CONTACT MVIEW FAILED." test@company.com /home/oracle/sql/refreshsql.log
exit 1
fi
Now, the result of this script is successful,meaning, the refresh.sql returns 'TRUE'. but I still get the email with subject ""REFRESHING FMLA CONTACT MVIEW FAILED."
My requirement is that I want the script to send email if the result of refresh.sql is false.
Please let me know the changes that needs to be done in above script.
Thanks
Last edited by Franklin52; 11-17-2009 at 03:05 PM..
Reason: Please use code tags!!
Hello people,
I am new to shell scripting and hoping to get a quick answer to my query.
I am writing a simple script which needs to call an executale which generates an output file. Once the output file is generated I have to do a couple of more task with that file. The executable ideally... (1 Reply)
Hi,
Can anyone please help me on building the logic for writing a shell script which can delete blank lines from a file and count the number of duplicate lines in a file.
Thanks,
Indra (2 Replies)
Hi,
Can someone help me with this small piece of code.
DIRNAME=$(dirname $0)
BASENAME=$(basename $0)
DATA="${DIRNAME}/${BASENAME}.data"
&& . $DATA
whats is meant by && . $DATA here...
Regards,
Abhishek (2 Replies)
Hello friends,
It will be great if we found some way to check this our:
we have some databases (teradata and oracle).
our applications(in java on weblogic) are using connection pools of these databases.
we have a pair of userID and password for every pool.
If we have any logic to test... (2 Replies)
There are two fields actually one is server name and the other one is Time.
Based on time, there are 8 columns and these will be updated with the flag 1 if at all if there is any server name.
Time
Server name
15 to 18
18 to 21
21 to 24
00 to 03
03 to 06
06 to 09
09 to 12
Server... (3 Replies)
Hello All,
I was wondering if someone can help me to develop restart logic for a Korn Shell program (a master script) that I am developing. The program is design to invoke a series of child processes (Korn Shell Scripts) whose function is to create a series of load files on a specified mount... (0 Replies)
Hi,
My input file as follws
$ cat 1.txt
-------
a aa aaa 11
b bb bbb 22
I am able to extract first and last column of a given line as follows.
$ nawk '{print $1}' FS= RS= 1.txt | awk '{ $NF = ""; print }'
a
$ nawk '{print $1}' FS= RS= 1.txt | awk '{ print $NF}'
11
however, the... (4 Replies)
Hi Unix Experts,
Happy Morning to all !! :)
I am new to UNIX Shell Scripting and at my begineer level. To get acquainted to scripting, I am trying to create a script.
The details/requirements of my script was to create a script with month changing logic in it so that on every 6th Working... (3 Replies)
Hi,
I need shell script for getting the date in format from below text output
IP IS 10.238.52.65
pun-ras-bng-mhs-01#show conf port 2/4
Building configuration...
Current configuration:
!
card ge3-4-port 2
!
port ethernet 2/4
no shutdown
encapsulation dot1q (7 Replies)
Hi I have a requirement where I have to generate a mail/alert to the user if any QA check is failed.
our oracle jobs run in unix environment and log file is created .
Sample is given below .
SELECT *
FROM product.fact_tally
WHERE period_id = '20130401' ;
LIMIT 5;
Ideally the above... (4 Replies)
Discussion started by: systemee
4 Replies
LEARN ABOUT DEBIAN
graphics::primitive::insets
Graphics::Primitive::Insets(3pm) User Contributed Perl Documentation Graphics::Primitive::Insets(3pm)NAME
Graphics::Primitive::Insets - Space between things
DESCRIPTION
Graphics::Primitive::Insets represents the amount of space that surrounds something. This object can be used to represent either padding
or margins (in the CSS sense, one being inside the bounding box, the other being outside)
SYNOPSIS
use Graphics::Primitive::Insets;
my $insets = Graphics::Primitive::Insets->new({
top => 5,
bottom => 5,
left => 5,
right => 5
});
METHODS
Constructor
new Creates a new Graphics::Primitive::Insets.
Instance Methods
as_array
Return these insets as an array in the form of top, right, bottom and left.
bottom
Set/Get the inset from the bottom.
equal_to
Determine if these Insets are equal to another.
left
Set/Get the inset from the left.
right
Set/Get the inset from the right.
top Set/Get the inset from the top.
zero
Sets all the insets (top, left, bottom, right) to 0.
AUTHOR
Cory Watson, "<gphat@cpan.org>"
SEE ALSO perl(1)COPYRIGHT & LICENSE
Copyright 2008-2010 by Cory G Watson.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.12.3 2010-08-21 Graphics::Primitive::Insets(3pm)