•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Shell Scripting section within the Software Development category of DaniWeb, a massive community of 427,065 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,346 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Shell Scripting advertiser: Programming Forums
Views: 843 | Replies: 5
 |
•
•
Join Date: Feb 2008
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi,
I am in need of writing a shell script to read, database table and email the results to a list of users.
Please let me know if I could provide further info.
Please assist.
Thanks,
-Abhey
I am in need of writing a shell script to read, database table and email the results to a list of users.
Please let me know if I could provide further info.
Please assist.
Thanks,
-Abhey
•
•
Join Date: Feb 2006
Location: Bristol, UK
Posts: 313
Reputation:
Rep Power: 3
Solved Threads: 13
Posting Whiz
hi can you give us any code you have written so far and a few lines of the database and what needs to be in the email format etc
If my post helped add to my rep!
•
•
Join Date: Feb 2008
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
•
•
•
•
Originally Posted by chris5126 
hi can you give us any code you have written so far and a few lines of the database and what needs to be in the email format etc
Hi, thanks for getting back to me.
To log into sql pls ( in the shell script. )
-- get the data.
$ORACLE_HOME/bin/sqlplus -s usr/pwd@database << EOF1 > msgbody
$LOGIN_PSWD
set feedback off
whenever sqlerror exit failure
EOF1
-- send email out.
cat msgbody | mailx -s "Subject:OnlyBody" someone@gmail.com
•
•
Join Date: Feb 2006
Location: Bristol, UK
Posts: 313
Reputation:
Rep Power: 3
Solved Threads: 13
Posting Whiz
d
Last edited by chris5126 : Feb 20th, 2008 at 3:58 am.
If my post helped add to my rep!
•
•
Join Date: Feb 2006
Location: Bristol, UK
Posts: 313
Reputation:
Rep Power: 3
Solved Threads: 13
Posting Whiz
hi what format is the data in within the spreadsheet e.g
name dob address car reg
or
name
dob
address
car reg
etc
and what format do you want the data to be in the email??
name dob address car reg
or
name
dob
address
car reg
etc
and what format do you want the data to be in the email??
If my post helped add to my rep!
•
•
Join Date: Feb 2008
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
Email would go to each sales rep
Subject line would be: commision paid
Body would be:
Commission paid for the following order
order no amt date
123 $2 2/2/08
345 $1 2/3/08 etc....
Please let me know if that helped.
Subject line would be: commision paid
Body would be:
Commission paid for the following order
order no amt date
123 $2 2/2/08
345 $1 2/3/08 etc....
Please let me know if that helped.
|
•
•
•
•
•
•
•
•
DaniWeb Shell Scripting Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- I'm jealous of Mac (Geeks' Lounge)
- Shell Script for Load monitoring! (Shell Scripting)
Other Threads in the Shell Scripting Forum
- Previous Thread: Killing of a process and send a mail if the process doesnot come up within 2 minutes
- Next Thread: memory usage display
