Help needed to send email


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help needed to send email
# 1  
Old 05-04-2010
Help needed to send email

Hi ,

Below is the part of Ksh.I have written.

The sql below generates list of records for undelivered letters.

## - spool undelivered letter list
cd $cs_LOG
$ORACLE_BIN/sqlplus $USER/$PASS @$cs_PROG/spool_undelivered_letters.sql

The below Ksh check for the file and send emails.

##if log file is not empty save it with the date and send email
if [ ! -s $cs_LOG/undelivered_letters.log ]; then
echo 'all letters delivered'
else
cp $cs_LOG/undelivered_letters.log $cs_LOG/undelivered_letters_age29.log.`date +%Y%m%d`
echo 'Undelivered letters check cust serv letters log directory ' `date` | /usr/bin/mailx \
-c test@yahoo.com \
-r eletters@xxx.com \
-s 'Undelivered letters' \
test@yahoo.com;
fi


But My problem is even though the spool does not contain any data it sends email.

The requirement is if undelivered_letters.log does not contain any data then we are not supposed to send the email.If it has data then we sould send email.
# 2  
Old 05-04-2010
It seems , the undelivered_letters.log file is having some data all the time. The logic you used here to check the "filesize" is correct and i strongly suspect the content of the file undelivered_letters.log
# 3  
Old 05-04-2010
yes . I always find the size of the undelivered_letters.log is 1k even though there is no records in it !
# 4  
Old 05-04-2010
Quote:
Originally Posted by sithara
yes . I always find the size of the undelivered_letters.log is 1k even though there is no records in it !
Ohh , in that case you need to check .sql logic to see whether you are properly spooling or not

use
Code:
sqlplus -s

to connect to the data base and use
Code:
SET options

available with SQL*Plus to turn everything off
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. SuSE

Send outgoing email to my GroupWise email

Dear users, I have Linux server whose versions are Suse 10 SP 3 and Suse 11. I am trying to send email from these servers to my GroupWise email account. In /etc/postfix/main.cf file, The current value of MYHOSTNAME is LINUX.LOCAL. What should be the right value of MYHOSTNAME? Is... (0 Replies)
Discussion started by: JDBA
0 Replies

2. Shell Programming and Scripting

send email to email id which is having # symbol

Hi, I have one requirement to send email to email id which is having # ( in the begining of the email id). I'm using mailx command to send an email. But not receiving those emails, but email status is showing email sent successful. Code which i'm using is : cat file1.txt | mailx -s... (3 Replies)
Discussion started by: latika
3 Replies

3. UNIX for Dummies Questions & Answers

new to ldap, send email to a ou or group, and see a list from email client

hi, i'm running openldap on ubuntu 10.04, creating new items with apache directory studio (windows version). i use the ldap just as an address book to our small office (email clients are windows live mail 2009, 2011, microsoft outlook 2007 and 2010). a. i cant see a list of the contacts,... (0 Replies)
Discussion started by: V4705
0 Replies

4. Shell Programming and Scripting

Script to send email after comparing the folder permissions to a certain permission & send email

Hello , I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them . I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
Discussion started by: nairshar
2 Replies

5. Shell Programming and Scripting

Help needed to send email

Hi , Below is the part of Ksh.I have written. The sql below generates list of records for undelivered letters. ## - spool undelivered letter list cd $cs_LOG $ORACLE_BIN/sqlplus $USER/$PASS @$cs_PROG/spool_undelivered_letters.sql The below Ksh check for the file and send emails. ... (1 Reply)
Discussion started by: sithara
1 Replies

6. Solaris

Send an email from Solaris using Linux email server

Hello everyone I have a problem and I need your help: I have a Solaris 10 and Solaris 8 UNIX Servers, and Linux Centos4 as email server. I need send an email from Solaris servers preferably using Centos4 email server. I have no mail service configured in my Solaris computers (1 Reply)
Discussion started by: aflores
1 Replies

7. UNIX for Dummies Questions & Answers

Send email where # is in the email address - Using Unix

Hi All, How do I send an email using malix where email address contains a #. I have a email address like this : #test@test.com I want to send email like malix -s "TEST" #test@test.com < SOMEFILE I tried \# but doesn't work. Please let me know how we can achieve this? I am in... (1 Reply)
Discussion started by: jingi1234
1 Replies

8. UNIX for Advanced & Expert Users

Unable to send eMail from a UNIX-Host ( using mailx ) to a Outlook-email-addres(Win)

Hi A) I am able to send eMail using mailx from a UNIX ( solaris 8 ) host to my Outlook-email-ID : FName.Surname@Citigroup.com ( This is NOT my actual -eMail-ID). But in Outlook the "From :" eMail address is displayed as " usr1@unix-host1.unregistered.email.citicorp.com " .i.e the words... (2 Replies)
Discussion started by: Vetrivela
2 Replies
Login or Register to Ask a Question