Variable not displaying in subject line of mailx email


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Variable not displaying in subject line of mailx email
# 1  
Old 07-31-2019
Variable not displaying in subject line of mailx email

Hi

Newbie here with first post. I've got a shell script (ksh) whereby I run a SQL*Plus script and output the results to a file. I then check the output file in an if statement that looks like this:

Code:
if [[ -e $OUTFILE ]]; then

export GAPNUM=`awk '{print $4}' $OUTFILE`

  if [[ $GAPNUM -ge 5 ]] then

  mailx -s "Possible Redo Apply Issue at $ORACLE_SID - Log Gap is "$GAPNUM" $MAIL_TO < $OUTFILE

  mv $OUTFILE $OUTFILE.$DAYHOUR

  fi

else

    echo "$OUTFILE does not exist" | mailx -s $SUBJECT $MAIL_TO
fi

Everything works fine except when the email is sent, although $ORACLE_SID value displays, $GAPNUM does not. I've searched on this site and others and am not sure what I'm doing wrong. If I place an echo $GAPNUM just before the mailx line it displays. What am I missing?

Thanks,

Laura

Last edited by Corona688; 07-31-2019 at 06:57 PM..
# 2  
Old 07-31-2019
You've got an extra quotation mark in there:
Code:
mailx -s "Possible Redo Apply Issue at $ORACLE_SID - Log Gap is "$GAPNUM" $MAIL_TO < $OUTFILE

Which might be swallowing up quite a bit of code below it.
This User Gave Thanks to Corona688 For This Post:
# 3  
Old 07-31-2019
Thanks Corona, but I'm not sure how that code in my post as it's not in my code. The line reads as-follows:

Code:
 mailx -s "Possible Redo Apply Issue at $ORACLE_SID - Log Gap is ${GAPNUM}" $MAIL_TO < $OUTFILE

Any other thoughts?

Thanks,

Laura
# 4  
Old 08-01-2019
Unless
Quote:
$OUTFILE
is a single line, this line will produce a variable with line breaks:
Quote:
awk '{print $4}' $OUTFILE
Update the statement to read a single variable.
# 5  
Old 08-01-2019
Hi rdrtx

Thanks, but that is a single line and works fine. My issue is that the variable $GAPNUM does not show in the subject line, even though the other variable in the subject line ($ORACLE_SID) does.

Thanks,

Laura
# 6  
Old 08-01-2019
Can you echo what "$GAPNUM" is set to prior to the mailx statement?
# 7  
Old 08-01-2019
Yup, did that and it echoes the correct value of 0, which stumped me even more. I totally don't understand why it displays in the previous line (i.e the echo) but not in the subject line.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Sending sql output to email body with conditional subject line

hi , i have written below piece of code to meet the requirement but i am stuck in the logic here. the requirement are: 1) to send the sql out put to email body with proper formatting. 2) if count_matching = Yes then mail should triggered with the subject line ... (10 Replies)
Discussion started by: itzkashi
10 Replies

2. Shell Programming and Scripting

Sendemail how to send an email with a subject variable

Hi,:) I try this : #!/bin/bash sender="me@example.com" recipient="you@example.com" subject="TEST FILE" server="0.0.0.0" file=$(cat file.txt) /usr/bin/sendemail -f $sender -t $recipient -u $subject -m $file My file.txt: BLABLALA BLABLABLA (7 Replies)
Discussion started by: Arnaudh78
7 Replies

3. Shell Programming and Scripting

Content of attachment is displaying along with subject in mailx

Hi All, I want to send the csv to an email address. I have tried the below two approaches. Approach1: Got error -ksh: uuencode: not found $ uuencode test_file.csv test_file.csv | mailx -s "Attaching test" msdc.kiran@gmail.com </usr/home/test_file.csv -ksh: uuencode: not found Approach2:... (6 Replies)
Discussion started by: ROCK_PLSQL
6 Replies

4. Shell Programming and Scripting

Subject line of an email

Hi all, I am trying to automate a process in which at the end of the process the script should send an email to the user saying this process is completed. I have done everything but the problem now is the subject line of the email... the subject line looks like this.. where abc xyz is a... (4 Replies)
Discussion started by: smarty86
4 Replies

5. Shell Programming and Scripting

help with script to send email and if subject line match is found

Help with script that will check log, then find a match is found, add that as the subject line. 1. The script will always run as a deamon.. and scan the event.log file 2. when a new 101 line is added to the event.log file, have the script check position 5,6 and 7 which is the job name, which... (2 Replies)
Discussion started by: axdelg
2 Replies

6. Shell Programming and Scripting

executing/including command in mailx subject line

Hi, Is it possible for me to include the results from a command in the subject line? What I am looking to do is get the file count and include it into the subject line as well as the list of files in the body. Example Subject line: Currently 25 files in directory My Code: #!/bin/ksh cd... (2 Replies)
Discussion started by: ozifer
2 Replies

7. Shell Programming and Scripting

Run a script based on the subject line of the email

Hi, I need help in running a script that would pull info from an email subject line and run a script (foo.sh). I'm pretty sure after a bit of googling that this is possible in several ways. but none was pretty clear on how to accomplish it. The part that I really need help with is getting the... (5 Replies)
Discussion started by: satekn
5 Replies

8. Shell Programming and Scripting

Email with subject contains value of Variable

I want to email where subject contains value of variable $ORACLE_SID. When script is emailing, it is not taking value of $ORACLE_SID. example - I have variable ORACLE_SID=prd I am sending email with below script. tail -1 $LOG | mailx -s 'Export Completed for ${ORACLE_SID}'... (2 Replies)
Discussion started by: deepsingh
2 Replies

9. UNIX for Advanced & Expert Users

Unable to send eMail from a UNIX-Host ( using mailx ) to a Outlook-email-addres(Win)

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

10. UNIX for Advanced & Expert Users

use email subject line as shell command

If anyone can give me some ideas on this it would be great. What I'm trying to do is to have emails be sent to my unix account. Once they are emailed to the unix account, I want to use the text in the subject field to invoke a shell script, so basically I need to find a way that I can... (4 Replies)
Discussion started by: mskarica
4 Replies
Login or Register to Ask a Question