Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

script not emailing or running

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting script not emailing or running
# 1  
Old 04-10-2009
script not emailing or running
Hi,

I am having trouble with this script. It is suppose to send me an email when the specified tablespace is 60% full. I run it but nothing happens


FREESPACELOG=/home/oracle/scripts/bin/free_space/freespace.sql
email=bob@bob.edu
subject="PROD: Tablespace Free Space"
cmd="mailx -s $subject $email"
awk -v c="$cmd" '$5>=60 && $1 == "IIQLOB01"{ system(c) }' "$FREESPACELOG"
# 2  
Old 04-10-2009
For the email to work you need to add double-quotes around the "$subject" because it has spaces in the text.
Code:
cmd="mailx -s \"$subject\" $email"

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Emailing results of a pl sql procedure from UNIX shell script

Hello All, I am writing the below unix script to email the result of a small pl sql procedure: #!/bin/bash ORACLE_HOME=/opt/oracle/orcts/product/9.2.0; export ORACLE_HOME SQLPLUS=$ORACLE_HOME/bin/sqlplus sqlplus -s user/pass@Db_instance<<EOF set echo off set feedback off set pages 0... (9 Replies)
Discussion started by: Bunty bedi
9 Replies

2. Shell Programming and Scripting

Crontab 2>&1 not emailing

I have a script that emails me when I run it manually, but the crontab I'm using must be 'silencing' the output? Here's what I have: */15 * * * * /usr/src/blah.sh > /dev/null 2>&1 I don't want it to email me every time it runs, just when I run the sendmail command inside the script if the... (13 Replies)
Discussion started by: unclecameron
13 Replies

3. Shell Programming and Scripting

Need help on conditional emailing

Hi All, The following databse table maintains VENDOR and EMAIL details. VENOR_NAME VENDOR_EMAIL DELL surendra@dell.com HP rajkamal@hp.com ACER sumathi@acer.com NOKIA kunal@nokia.com SONY sinu@sony.com We have to find emaild id of a vendor based... (7 Replies)
Discussion started by: ROCK_PLSQL
7 Replies

4. Shell Programming and Scripting

CLI script for emailing alert if files missing in dir

thread removed (4 Replies)
Discussion started by: billabongjimmy
4 Replies

5. UNIX for Dummies Questions & Answers

Shell script emailing issue

Hi, Im writing a shell script: #!/bin/bash #Send process which has exceeded 25% # echo 'pri pid user nice pcpu command' > /export/home/tjmoore/file2 # if ps -eo pri,pid,user,nice,pcpu,comm | awk '{if($5 >= 25)print $0}' >> /export/home/tjmoore/file2 2>/dev/null # # # then... (1 Reply)
Discussion started by: jay02
1 Replies

6. Shell Programming and Scripting

Help in scripting for emailing notificatons

Hi all, I have a table like this: Name email booking no xyz xyz@abc.com 1235 pqr pqr@abc.com 2536 xyz xyz@abc.com 5896 we have to send a notification to all distinct email ids with consolidated booking information in a single mail. i.e., 1235 2536 with some subject has... (6 Replies)
Discussion started by: dineshnarra
6 Replies

7. Shell Programming and Scripting

Automate emailing via shell script

Hi, I am struggling to send my email via shell script. I can type the command in and it works pefectly: mail -s "subject" email@email.co.email < text_to_sendHowever if I try and automate it it fails. I have tried setting variables for all aspects (mail, email addr, subject, message) with no... (3 Replies)
Discussion started by: mcclunyboy
3 Replies

8. Shell Programming and Scripting

emailing as body of email

hi all, how do i email a file in the body of an email rather than as an attachment ?? have a ksh script which i need to read a file and email as part of the body rather than an attachment. my code is : uuencode file.log | mailx -s "test" but this sends file as an attachment. ... (2 Replies)
Discussion started by: cesarNZ
2 Replies

9. Shell Programming and Scripting

Copying files and emailing them out

Hello everybody, I'm trying to create a script that will cd into a directory and then copy the file with yesterday's date on it and then cd into another directory doing the same thing. Afterwards, i'm trying to zip up the two files, and email them out to people. Can anyone help? thanks a... (1 Reply)
Discussion started by: jhofilena
1 Replies

10. UNIX for Dummies Questions & Answers

SMTP - emailing issue

We are running an application engine program that sends email to a list of users. In our Test Env, users are able to receive the emails but in our Prod environment, they do not. We are running the same program, and using the same stmp config. any idea on how to troubleshoot? (3 Replies)
Discussion started by: tads98
3 Replies
Login or Register to Ask a Question