|
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !! |
More UNIX and Linux Forum Topics You Might Find Helpful
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| display HTML text in body using unix mailX ???? | sparan_peddu | UNIX for Advanced & Expert Users | 8 | 07-30-2008 02:23 AM |
| Can any body tell me. | sackNumchai | Linux | 3 | 05-06-2008 01:28 AM |
| Mailx : can we have the body to be a binary file ? | CKIRCH | UNIX for Dummies Questions & Answers | 5 | 01-01-2008 07:33 PM |
| mailx: concatenating strings for message body (KSH) | rockysfr | Shell Programming and Scripting | 1 | 07-29-2007 09:12 AM |
| mailx error message : mailx: NUL changed to @ | BG_JrAdmin | UNIX for Dummies Questions & Answers | 2 | 12-01-2005 10:27 AM |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
10-05-2006
|
||||
|
||||
|
MAILX Body containing SQL results
I have a KSH script that runs a SQL script, then sends an email to me indicating that it's completed. I would like to modify it so that the body of the email will contain a count of the number of records Added, Changed, Deleted as a result of the SQL script. Here's what I was trying, but it's not working...what am I doing wrong? Code:
MESG_GOOD="Completed Successfully" cntADD=sqlplus -s user/pwd select count(*) from tbl where...; cntCHA=sqlplus -s user/pwd select count(*) from tbl where...; cntDEL=sqlplus -s user/pwd select count(*) from tbl where...; content="Adds: " && cntADD && "Changes: " && cntCHA && "Deletes: " &&cntDEL /usr/bin/echo $content | /usr/bin/mailx -s $MESG_GOOD me@here.com Last edited by dstinsman; 10-05-2006 at 04:50 PM.. |
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Threaded Mode
