topic Re: How to get output of sql script in mail? in Operating System - HP-UX

How to get output of sql script in mail?

Deepu Chakravarty — Wed, 11 Jan 2006 01:31:38 GMT

I have setup unix sendmail in HP-UX 11.11 box. I can send Mail from my unix box to smtp mail login id (NT box)(through .forward file)successfully. Now my requirement is as follows:
1. I need output of my selected oracle sql scripts in my smtp mail login id.
This oracle script can be run with cron job in the unix box and output should be mailed to my smtp mail login id.
Help is required to setup this requirement.

Thanks in advance.

Re: How to get output of sql script in mail?

Muthukumar_5 — Wed, 11 Jan 2006 01:34:30 GMT

Execute the sql scripts and pipe into smtp mail login id.

./sqlscript | mailx -s "SQL output" mailId

it will do that.

Else redirect sql script execution results to a log file as,

$ ./sqlscript 1>/tmp/sql.log 2>&1
$ mailx -s "SQL Output" mailID < /tmp/sql.log

--
Muthu

Re: How to get output of sql script in mail?

Steven E. Protter — Wed, 11 Jan 2006 01:36:39 GMT

Shalom Deepu,

Any output can be redirected to email:

script | mailx -s "sql stuff" your@yourmail.com

If its big, you can just do it as an attachment.

http://www.hpux.ws/mailfile2

This little gem uses sendmail to send large files as an attachment.

SEP

Re: How to get output of sql script in mail?

Muthukumar_5 — Wed, 11 Jan 2006 01:38:57 GMT

If you want to attach the script executed log informations then use uuencode with mailx as,

$ ./script > /tmp/sql.log
$ uuencode /tmp/sql.log sql.log | mailx -s "subject" mailid

--
Muthu

Re: How to get output of sql script in mail?

Yogeeraj_1 — Wed, 11 Jan 2006 02:02:32 GMT

hi,
you can also send directly from Oracle itself using the Utl_Smtp package.

see the following link:
http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/Utl_Smtp_Sample.html

hope this helps!

kind regards
yogeeraj

Re: How to get output of sql script in mail?

Deepu Chakravarty — Wed, 11 Jan 2006 02:10:23 GMT

Hi Guys,
Thanks.

Pls clarify the following;
1 How sendmail will pick up the output from .forward file ?
Since output will be generated through a cron job to a out file.

Re: How to get output of sql script in mail?

Steven E. Protter — Wed, 11 Jan 2006 02:17:50 GMT

Shalom,

sendmail's checks local mail via user name. If a .forward file is present, it is used to route the mail.

This is built into the standard sendmail.cf file. You can read it and search for forward or .forward

SEP

Re: How to get output of sql script in mail?

Deepu Chakravarty — Wed, 11 Jan 2006 23:45:53 GMT

SHALOM,

Thanks to everyone who were participated in this thread. The issue is resolved.

Re: How to get output of sql script in mail?

Deepu Chakravarty — Wed, 11 Jan 2006 23:49:11 GMT

SEP's and Muthu's suggestion seemed to be more effective. However I thank to everyone who were participated in this thread.