sending mail using Mailx with data from oracle table
Hi,
i need to send emails to the mail ids i receive using the sql query .
i will be getting multiple number of rows of data for this query, and i need to send mail to each row of data with the content received for that row.
sample data
Quote:
ALARM_DEF CRITERIA DISTANCE_METRE EMAIL LAC_ID LAST_CHECK RANGE RESOURCE_MSISDN ADDRESS NAME
went out OUT 146.321857 aemunathan.r@gmail.com 40 16-Apr-10 17:24:01 100 919191919191 HRD OFFICE
Aemu Left the office OUT 1167.764448 41 16-Apr-10 19:12:01 1000 919191919191 HRD OFFICE
vanthuru vanthuru IN 146.321857 l@yahoo.com 39 16-Apr-10 17:24:01 1000 919444008844 HRD OFFICE
i need to send the email to say for e.g aemunathan.r@gmail.com --first row of data......
this way i need to snd to all records and update the NOTIFY_STATUS column in my table to 1 once mail sent, so that same mail wont be sent again... .
pls guide me how to proceed...
---------- Post updated at 08:41 AM ---------- Previous update was at 12:14 AM ----------
Hi,
i tried the following way...but not tasted success...
error thrown is
Quote:
The flags you gave are used only when sending mail.
Usage: mailx -eiIUdFntBNHvV~ -T FILE -u USER -h hops -r address
-s SUBJECT -f FILE users
The flags you gave are used only when sending mail.
Usage: mailx -eiIUdFntBNHvV~ -T FILE -u USER -h hops -r address
-s SUBJECT -f FILE users
The flags you gave are used only when sending mail.
Usage: mailx -eiIUdFntBNHvV~ -T FILE -u USER -h hops -r address
-s SUBJECT -f FILE users
while trying to send a mail, though the output file doesn't contain any exclamatory mark(!), i am getting that in the mail with an extra line. please help me out from this ASAP. (3 Replies)
Hi All,
Please help me regarding sending mails using mailx command in unix.
I will be glad if some one give me the sintax of this. I tried using the below but vain.
mailx -s 'Hi' 'xyz@abc.com'
Regards,
Manas (5 Replies)
hi All,
i am trying to send a mail from perl using mailx.
the script runs fine if i hard code the file path which is to be attached to the mail. but when i give a variable containing the path of the file , perl is not able to send the file.
ex:
system('uuencode /attach/test.txt... (3 Replies)
Hi
I need help to send mail through mailx command . Currenlt my program is like
#!/bin/ksh -x
echo " " >> path.lst
MAIL_LIST='someone1@gamil.com someone2@gamil.com someone3@gamil.com'
cat path.lst | mailx -s "path loaction" $MAIL_LIST
echo "End"
exit 0
Its work fine . But i... (3 Replies)
Hi All,
OS:Red Hat Linux 4 86x64
Below is my shell script which is not sending mail to the mail recipient:
#!/bin/bash
export MAILLIST="xyz@yahoo.com"
cd <path_to_the_script_perf_report.sql>
sqlplus / as sysdba @perf_report.sql
if
then
cat <path_to_the_script/*MONTHLY*REPORT*.lst... (6 Replies)
How to embed a html file as subject in a mail sending from Linux box with uuencode or mailx or any other way?
we do not want the file as attachment, it should be embedded in the mail subject. (2 Replies)
Is anyone here know how to make a script in UNIX which will do importing data from PL/SQL then sending it through mail? Can you give me sample script with explanation so it's easy to understand,Thank you very much,any suggestion or advice is welcome, (1 Reply)
Hi All,
I have a unix server on which mailx is configured . Earlier i was getting proper mails but now some mails are getting stuck and i am not receiving the emails from the server.
I can see the mails in mailq.
Can you please help me with this . How can i receive these emails? (2 Replies)
I have to send a couple of rows that have been returned from a SQL query. I have written the output of the query to a file and while i try to print this in the mail body the formatting goes wrong.
Intended Output in mail body:
Col1 Col2 Col3
------ ... (2 Replies)
Whats the difference between mail and mailx?
I'm trying to troubleshoot a problem where I can send mail from server A with this `echo $MESSAGE | mail -s "$SUBJECT" -r $FROM $RECIPIENTS` command but executing the same command from server B throws me this error (Both servers are RHEL)
... (1 Reply)