07-11-2009
Issues while sending a mail having records fetched from SQL -all in UNIX
hi-I want to write a UNIX Script which will fetch records from Oracle database.I want to store these records in a file under fields like email address,name and the transaction_id and then fetch these records from the file and send the email to individual users with their transaction ID details.
8 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am using mailx command to send mail through Unix. But I am able to send mail only within my domain. If i want to send mail to some other server, it's not working. Like say If I want to send mail to someone on gmail or yahoo it's not working. but it's working fine within my company domain.... (3 Replies)
Discussion started by: anki_1
3 Replies
2. Shell Programming and Scripting
Dear Friends,
I have a shell script where the mail is being sent like this:
/usr/lib/sendmail -v ${CPA_ADMIN}
CPA_ADMIN="xx@abc.com"
Can we specify more than one email ids in this variable?
Is ther eany limit to the number of email ids I can specify in this variable, to whom the mail... (3 Replies)
Discussion started by: Radhe
3 Replies
3. Shell Programming and Scripting
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)
Discussion started by: Atrap
1 Replies
4. Shell Programming and Scripting
Hi all,
My reqirenet goes like this.
Need to execute one select statement within the script and send a mail to the users with the number of records fecthed from the query.
Please help..
Thanks. (3 Replies)
Discussion started by: Achiever
3 Replies
5. UNIX for Dummies Questions & Answers
Hi,
i am trying the below script for sending mail.
if
then
count=`cat $sfile|wc -l`
echo "There are $count abends.Please take care " > body.txt
(cat body.txt;uuencode $sfile $sfile) | mailx -s "Alert:there are failures" pandeesh@gmail.com
fi
In the mail, i am getting like:
... (4 Replies)
Discussion started by: pandeesh
4 Replies
6. UNIX for Dummies Questions & Answers
Hi
I am using the below command to send mail from unix with body as well as attachment.
But the attachment is in encoded form in the body itself.
I am not receiving as attachment:
(cat body_success.txt;uuencode Log.txt Log.txt)| mailx -s "success" $ToID
I am receiving... (5 Replies)
Discussion started by: pandeesh
5 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I want to send an email from unix. I tried following commands:
mailx -s "hello" manish.xxx@xxx.com < echo_manish
and
echo "Testing Mail" | mailx -s "hello" manish.xxx@xxx.com
but in both the commands nothing is happening. I mean it is neither giving any error nor I am receiving... (7 Replies)
Discussion started by: manishdivs
7 Replies
8. Shell Programming and Scripting
I'm unable to send email from my Linux server despite SMTP port 25 Active and Listening.
# hostname
TechX
I checked the mail log ( /var/log/maillog ) and found the below error.
I'm sharing all the ".cf" files seen in the error log.
1.
# more /etc/postfix/main.cf
# postfix... (0 Replies)
Discussion started by: mohtashims
0 Replies
LEARN ABOUT CENTOS
script-email
SCRIPT-EMAIL(8) System Administration Commands SCRIPT-EMAIL(8)
NAME
script-email - Amanda script to send email notifications
DESCRIPTION
script-email is an Amanda script implementing the Script API. It should not be run by users directly. It sends a notification email to the
addresses specified in the MAILTO property.
PROPERTIES
This section lists the properties that control script-email's functionality. See amanda-scripts(7) for information on the Script API,
script configuration.
MAILTO
List of email addresses that will receive an email on command execution. It is a multi-valued property:
property "MAILTO" "amanda@domain.com" "sysadmin@domain.com" "amandauser@domain.com"
EXAMPLE
In this example, script-email is scheduled to be run before the DLE, on the server. The unqualified email address amanda will be passed to
the email system unchanged. The script is then attached to a dumptype, which can then be specified for any DLEs which require
notification.
define script-tool pre-email {
comment "email me before this DLE is backed up"
plugin "script-email"
execute-on pre-dle-backup
execute-where server
property "mailto" "amanda"
}
define dumptype user-tar-email {
user-tar
script "pre-email"
}
SEE ALSO
amanda(8), amanda.conf(5), amanda-client.conf(5), amanda-scripts(7)
The Amanda Wiki: : http://wiki.zmanda.com/
AUTHORS
Jean-Louis Martineau <martineau@zmanda.com>
Zmanda, Inc. (http://www.zmanda.com)
Dustin J. Mitchell <dustin@zmanda.com>
Zmanda, Inc. (http://www.zmanda.com)
Amanda 3.3.3 01/10/2013 SCRIPT-EMAIL(8)