06-25-2009
Send email for each row in a result set
I have SQL giving me output of disabled ids in the system every day.
I can send on email for this disabled user list.
But I want to send one email for every disabled user or for every row.
thank you for your help.
Kyle
9 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
2. Shell Programming and Scripting
Hi,
i want to create a script which should do the following:
1) ping the remote servers and email the hosts which are down
2) netstat on port x on 2 server and email the result too.
I want both results to be sent in the same email.
I have few ideas but i can't finish it.
Here... (4 Replies)
Discussion started by: varu0612
4 Replies
3. Shell Programming and Scripting
I want to send email for every row comes out of following SQL statement
thank you for your help.
*****SQL STATEMENT******
Select SCUSER AS "USER IDS" , SCEUSER AS "LOCKED OUT" FROM SYS.7333.F98OWSEC;
*******OUPUT COMES LIKE THIS AND ONE EMAIL COMES AS PER SCRIPT BELOW******
******BUT... (4 Replies)
Discussion started by: s1a2m3
4 Replies
4. Solaris
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
5. Shell Programming and Scripting
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
6. UNIX for Dummies Questions & Answers
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
7. Shell Programming and Scripting
Comparing two files on row by row
File1
ecount~100
dcount~200
ccount~300
zxcscount~5000
and so on.
File2
ecount~100
dcount~203
ccount~300
zxcscount~5000
and so on.
If i use diff command (1 Reply)
Discussion started by: onesuri
1 Replies
8. Shell Programming and Scripting
i have below code to count number of rows in file1.txt, if the row count is more than one then i have sending an email along with file1.txt attached and fail the process(do nothing if count is <=1),
if I test individually count part works good but when i include the email part its not working,... (1 Reply)
Discussion started by: srini_106
1 Replies
9. SuSE
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
LEARN ABOUT DEBIAN
pygm2n
pygm2n(1) Python Gateway mail to news pygm2n(1)
NAME
pygm2n - Python Gateway mail to news
SYNOPSIS
pygm2n -n newsgroups [ -s newsserver ] [ -h ]
DESCRIPTION
IMPORTANT: this man page is to be continued. The Whole pyg gateway is in devel. state. try -h option for more detailed option.
pygm2n reads from stdin an email, sending it to newsgroups, a comma separated list without spaces of newsgroup names (at least one), rfc799
compliant.
If pygm2n reads from stdin a sigle line starting with /, it is considered an absolute path to a single-email mailbox, so pygm2n will open
and read it.
Note that now pyg can't read a real mailbox, with many emails. If you give it in input, pyg will post the whole mailbox as a single email.
EXAMPLES
There is some documetation in /urs/share/doc/pyg
I created mailgate user (moderator of local.moderated ng). Subscribe to a list with this user (or simply email one message to). Every
email posted to this user will send to newsgroups, in its .procmailrc I've put something like:
:0 bh * ^From *mailinglist-request@lists.debian.org | $HOME/pygm2n -n local.debian.mailinglist
AUTHORS
Cosimo Alfarano <alfarano@students.cs.unibo.it>
BUGS
Boh. send any bug, advice or opinion to the author, please.
Sun Sep 12 18:10:00 CEST 2000 pygm2n(1)