10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
9 Replies
2. Shell Programming and Scripting
Hi ,
I have a sql query in the unix script ,whose output is shown below.I want to convert this output to HTML table format & send email from unix with this table as email body.
p_id src_system amount
1 A 100
2 B 200
3 C ... (3 Replies)
Discussion started by: jagadeeshn04
3 Replies
3. UNIX for Dummies Questions & Answers
Please read How To Ask Questions The Smart Way (1 Reply)
Discussion started by: balu_279013
1 Replies
4. Red Hat
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Discussion started by: ramsavi
5 Replies
5. Shell Programming and Scripting
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Discussion started by: Kapom
2 Replies
6. Shell Programming and Scripting
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
Hi Friends,
I am using AIX version and sqlplus to connect to database while writing a shell script.
I have implemented three ways to connect to database :
1)
sqlplus -s <USERNAME>/<PASSWORD> <<!
@<SQL FILE TO EXECUTE>
exit
!
2)
sqlplus -s <USERNAME>/<PASSWORD> <<!
-----sql statemenets... (6 Replies)
Discussion started by: gauravgarg
6 Replies
8. Shell Programming and Scripting
Hi,
We need a script that invokes the sql query every 14 days ans send email (0 Replies)
Discussion started by: bujjisveeru
0 Replies
9. Shell Programming and Scripting
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
Discussion started by: kingluke
2 Replies
10. UNIX for Dummies Questions & Answers
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
SEND-REMINDERS(1) User Contributed Perl Documentation SEND-REMINDERS(1)
NAME
Send-reminders - send email reminders for special occasions
SYNOPSIS
Send emails reminders set by users for special occasions.
DESCRIPTION
Email-reminder allows users to define events that they want to be reminded of by email. Possible events include birthdays, anniversaries
and yearly events. Reminders can be sent on the day of the event and a few days beforehand.
This script is meant to be invoked everyday by a cron job. It mails the actual reminders out.
When run by the root user, it processes all of the spooled reminders. When run by a specific user, it only processes reminders set by that
user.
OPTIONS
--help
Displays basic usage message.
--simulate
Does not actually send any emails out.
--verbose
Prints out information about what the program is doing, including the full emails being sent out.
--version
Displays the version number.
FILES
~/.email-reminders, /etc/email-reminder.conf
AUTHOR
Francois Marier <francois@email-reminder.org.nz>
SEE ALSO
email-reminder-editor, collect-reminders
COPYRIGHT
Copyright (C) 2004-2010 by Francois Marier
Email-Reminder is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 3 of the License, or (at your option) any later version.
Email-Reminder is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with Email-Reminder; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
perl v5.14.2 2012-05-28 SEND-REMINDERS(1)