Sponsored Content
Full Discussion: Send Email using Korn Shell
Top Forums Shell Programming and Scripting Send Email using Korn Shell Post 302407773 by atlurip on Friday 26th of March 2010 11:12:03 AM
Old 03-26-2010
Send Email using Korn Shell

Hi All,

I need assistance is sending email out using korn shell

Steps,
1- Count number of records in database.
2- if count is more than 2000
3- send email to user else if less then 1999 exit out.

Here is my script and is not exiting out and need to press .DOT and Enter command to get out of the script then it sends out email.

Code:
 
#!/bin/ksh
 
VALUE=$( sqlplus -s username/password <<EOF
 set heading off;
 set serveroutput on;
 select count(*) from <Table_NAME>;
 quit
EOF)
size=2000
if  [[ $VALUE -gt $size ]]; then
mail -s "Table_name count is greater then 2000" email_user@xxx.com ;
else
echo "All clear.."
exit
fi;

- How can the script comes out gracefully.

Please asistance.

Thank you!

Last edited by vbe; 03-26-2010 at 12:50 PM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Shell to run query, encrypt and send email

Hello To do : 'automate the process of generating report and send it to client every 15 days after encrypting the report file' Did so far : - generate Java program to encrypt the file. - generate SQL query to run the report. Is there any body who can help me to go further ? ... (7 Replies)
Discussion started by: cub
7 Replies

2. Shell Programming and Scripting

How to write a shell script to send an email to an id

Hi all, I want to know how to send an email using shell script ..... I tried a command call mail but it did not work.. Please any one reply.. With example if you know thanks.. Madhu (4 Replies)
Discussion started by: madhumathikv
4 Replies

3. Shell Programming and Scripting

shell send html email

I know how to send an email with sendmail in a shell script. I know how to send an email with an attachment in a script. But im trying to send an email and need to set Content-Type to text/html and insert a file as the body and not attachment. Send email with file as attachment: ... (4 Replies)
Discussion started by: Ikon
4 Replies

4. Shell Programming and Scripting

make un shell script to send email

Hi, Someone Knows how to obtein a chain from a unix file, but not all the line, for exemple, for this file ,obtein only 902111111 and to keep the value, this value will be used to make a mailx. NF=ALL, SUBJ= FROM: SN=CD, SE=TOPCALL, NA=, N=902111111, N=TCLFI TO: SE=FAX, NA=, C1=... (0 Replies)
Discussion started by: peybol
0 Replies

5. Shell Programming and Scripting

How to send email through shell script

Hi All, I am new to the unix , i have to deliver one script very urgently I have to write a shell script where i have i want to send email to specific email id in this script i want FROM to be parameterized and stored in a variable TO to be parameterized and stored in a variable... (3 Replies)
Discussion started by: nileshbhawsar
3 Replies

6. 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

7. Shell Programming and Scripting

Shell script to send an email from the txt file

Hi Friends, Could you guys help me out of this problem... I need to send an email to all the users and the email has to be picked from the text file. text file contains the no. of records like: giridhar 224285 847333 giridhar276@gmail.com ramana 84849 33884 venkata.ramana@gmail.com... (6 Replies)
Discussion started by: giridhar276
6 Replies

8. Shell Programming and Scripting

Help with shell script to send email once

Hi Guys, I have this script which will monitor oracle db process if up or down.And I want it to send email if it's down and the time it's back to online. However my script just keep on sending "Email Up" if the db is up or "Email Down" if the db is down.Is there any way to trap it so that it... (5 Replies)
Discussion started by: d3xt3r
5 Replies

9. Shell Programming and Scripting

Send email from shell to users in Mysql

Hi, I need help about sending mail in linux. I have a ubuntu server with working web site, users are uploading files in one main directory (to folder inbox). With samba I shared that directory and on other mashine is Windows server and application that is reading that files and writting content to... (3 Replies)
Discussion started by: drazenmd
3 Replies

10. Shell Programming and Scripting

how to send html email from shell script

This is my below script which is working fine as it send only plain text email. So My question is- How can I modify my below script to send this as an HTML formatted email? I want to show the text color of this expression `(echo "100*$TEST2/$TEST1" | bc -l)` as `RED` in an email and that can be... (3 Replies)
Discussion started by: raihan26
3 Replies
Email::Send(3pm)					User Contributed Perl Documentation					  Email::Send(3pm)

NAME
Email::Send - Simply Sending Email WAIT! ACHTUNG! Email::Send is going away... well, not really going away, but it's being officially marked "out of favor." It has API design problems that make it hard to usefully extend and rather than try to deprecate features and slowly ease in a new interface, we've released Email::Sender which fixes these problems and others. As of today, 2008-12-19, Email::Sender is young, but it's fairly well-tested. Please consider using it instead for any new work. SYNOPSIS
use Email::Send; my $message = <<'__MESSAGE__'; To: recipient@example.com From: sender@example.com Subject: Hello there folks How are you? Enjoy! __MESSAGE__ my $sender = Email::Send->new({mailer => 'SMTP'}); $sender->mailer_args([Host => 'smtp.example.com']); $sender->send($message); # more complex my $bulk = Email::Send->new; for ( qw[SMTP Sendmail Qmail] ) { $bulk->mailer($_) and last if $bulk->mailer_available($_); } $bulk->message_modifier(sub { my ($sender, $message, $to) = @_; $message->header_set(To => qq[$to@geeknest.com]) }); my @to = qw[casey chastity evelina casey_jr marshall]; my $rv = $bulk->send($message, $_) for @to; DESCRIPTION
This module provides a very simple, very clean, very specific interface to multiple Email mailers. The goal of this software is to be small and simple, easy to use, and easy to extend. Constructors new my $sender = Email::Send->new({ mailer => 'NNTP', mailer_args => [ Host => 'nntp.example.com' ], }); Create a new mailer object. This method can take parameters for any of the data properties of this module. Those data properties, which have their own accessors, are listed under "Properties". Properties mailer The mailing system you'd like to use for sending messages with this object. This is not defined by default. If you don't specify a mailer, all available plugins will be tried when the "send" method is called until one succeeds. mailer_args Arguments passed into the mailing system you're using. message_modifier If defined, this callback is invoked every time the "send" method is called on an object. The mailer object will be passed as the first argument. Second, the actual "Email::Simple" object for a message will be passed. Finally, any additional arguments passed to "send" will be passed to this method in the order they were received. This is useful if you are sending in bulk. METHODS send my $result = $sender->send($message, @modifier_args); Send a message using the predetermined mailer and mailer arguments. If you have defined a "message_modifier" it will be called prior to sending. The first argument you pass to send is an email message. It must be in some format that "Email::Abstract" can understand. If you don't have "Email::Abstract" installed then sending as plain text or an "Email::Simple" object will do. Any remaining arguments will be passed directly into your defined "message_modifier". all_mailers my @available = $sender->all_mailers; Returns a list of availabe mailers. These are mailers that are installed on your computer and register themselves as available. mailer_available # is SMTP over SSL avaialble? $sender->mailer('SMTP') if $sender->mailer_available('SMTP', ssl => 1); Given the name of a mailer, such as "SMTP", determine if it is available. Any additional arguments passed to this method are passed directly to the "is_available" method of the mailer being queried. Writing Mailers package Email::Send::Example; sub is_available { eval { use Net::Example } } sub send { my ($class, $message, @args) = @_; use Net::Example; Net::Example->do_it($message) or return; } 1; Writing new mailers is very simple. If you want to use a short name when calling "send", name your mailer under the "Email::Send" namespace. If you don't, the full name will have to be used. A mailer only needs to implement a single function, "send". It will be called from "Email::Send" exactly like this. Your::Sending::Package->send($message, @args); $message is an Email::Simple object, @args are the extra arguments passed into "Email::Send::send". Here's an example of a mailer that sends email to a URL. package Email::Send::HTTP::Post; use strict; use vars qw[$AGENT $URL $FIELD]; use Return::Value; sub is_available { eval { use LWP::UserAgent } } sub send { my ($class, $message, @args); require LWP::UserAgent; if ( @args ) { my ($URL, $FIELD) = @args; $AGENT = LWP::UserAgent->new; } return failure "Can't send to URL if no URL and field are named" unless $URL && $FIELD; $AGENT->post($URL => { $FIELD => $message->as_string }); return success; } 1; This example will keep a UserAgent singleton unless new arguments are passed to "send". It is used by calling "Email::Send::send". my $sender = Email::Send->new({ mailer => 'HTTP::Post' }); $sender->mailer_args([ 'http://example.com/incoming', 'message' ]); $sender->send($message); $sender->send($message2); # uses saved $URL and $FIELD SEE ALSO
Email::Simple, Email::Abstract, Email::Send::IO, Email::Send::NNTP, Email::Send::Qmail, Email::Send::SMTP, Email::Send::Sendmail, perl. PERL EMAIL PROJECT
This module is maintained by the Perl Email Project. <http://emailproject.perl.org/wiki/Email::Send> AUTHOR
Current maintainer: Ricardo SIGNES, <rjbs@cpan.org>. Original author: Casey West, <casey@geeknest.com>. COPYRIGHT
Copyright (c) 2005 Casey West. All rights reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.12.4 2011-08-31 Email::Send(3pm)
All times are GMT -4. The time now is 10:26 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy