06-25-2002
Shell to run query, encrypt and send email
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 ?
Thanks in advance.
10 More Discussions You Might Find Interesting
1. 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
2. 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
3. Shell Programming and Scripting
Hi All,
I need assistance is sending email out using korn shell
Steps,
1- Count number of records in database.
2- if count is more than 2000
3- send email to user else if less then 1999 exit out.
Here is my script and is not exiting out and need to press .DOT and Enter command to... (2 Replies)
Discussion started by: atlurip
2 Replies
4. Shell Programming and Scripting
Hi All,
I am new to the unix , i have to deliver one script very urgently
I have to write a shell script where i have i want to send email to specific email id
in this script i want
FROM to be parameterized and stored in a variable
TO to be parameterized and stored in a variable... (3 Replies)
Discussion started by: nileshbhawsar
3 Replies
5. 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
6. Shell Programming and Scripting
Hi Guys,
I have this script which will monitor oracle db process if up or down.And I want it to send email if it's down and the time it's back to online. However my script just keep on sending "Email Up" if the db is up or "Email Down" if the db is down.Is there any way to trap it so that it... (5 Replies)
Discussion started by: d3xt3r
5 Replies
7. 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
8. 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
9. Shell Programming and Scripting
Team,
Would like to know what is the best script that will send you an email if cronjob did not run.
Thanks (4 Replies)
Discussion started by: kenshinhimura
4 Replies
10. Shell Programming and Scripting
I am currently try to write a simple script with the following condition, but so far not having luck as the exit code would always be 0.
Run remote command to read a file and grep for test word.
if test word is in the file, send email.
if not, do nothing
also possible to ssh to multiple... (3 Replies)
Discussion started by: jaapar
3 Replies
LEARN ABOUT CENTOS
reporter-mailx
REPORTER-MAILX(1) LIBREPORT MANUAL REPORTER-MAILX(1)
NAME
reporter-mailx - Sends contents of a problem directory via email.
SYNOPSIS
reporter-mailx [-v] -d DIR [-c CONFFILE]
DESCRIPTION
The tool reads a problem directory, composes an email message from the directory contents, and uses mailx to send the message to specified
recipient.
Properties of email messages can be specified in a configuration file, and via environment variables.
Configuration file
Configuration file contains entries in a format "Option = Value".
The options are:
Subject
The subject of the email message.
EmailFrom
The sender of the email message.
EmailTo
The recipient of the email message.
SendBinaryData
Use yes/true/on/1 to attach all binary files from the problem directory to the email. This can cause the emails to be very large.
Integration with ABRT events
reporter-mailx can be used as a reporter, to allow users report problems via email when they decide to do it. This usage is pre-configured
in /etc/libreport/events.d/mailx_event.conf:
EVENT=report_Mailx reporter-mailx
It can also be used to notify administrator automatically when a problem happens. When this is desired, modify the event configuration file
to run the tool on the post-create event:
EVENT=post-create reporter-mailx
OPTIONS
-d DIR
Path to problem directory.
-c CONFFILE
Path to configuration file. When used in ABRT event system, the file contains site-wide configuration. Users can change the values via
environment variables.
ENVIRONMENT VARIABLES
Environment variables take precedence over values provided in the configuration file.
Mailx_Subject
Subject of the email message.
Mailx_EmailFrom
Sender of the email message.
Mailx_EmailTo
Recipient of the email message. If nor the environment variable nor the corresponding option is defined, the message is send to
"root@localhost".
Mailx_SendBinaryData
Use yes/true/on/1 to attach all binary files from the problem directory to the email.
AUTHORS
o ABRT team
LIBREPORT 2.1.11 06/18/2014 REPORTER-MAILX(1)