Problem with BLAT; was: Oracle NT Automatic mailing

Hi!

I tried the steps that Jeff has given below. I want a tablespace report to be mailed to me every day.

1. copied the file to winnt/system32
2. when I ran the install routine, I get this:

   c:\>Blat -install mail.company.com PEPE_on_DEVDATA_at_company.com    Failed to open registry key for Blat profile , using default.

   SMTP server set to mail.company.com on port with user PEPE_on_DEVDATA_at_company.com, retry 1 time(s)

Then I tried it again:

   c:\>Blat -install mail.company.com PEPE_on_DEVDATA_at_company.com

   SMTP server set to mail.company.com on port with user PEPE_on_DEVDATA_at_company.com, retry 1 time(s)

3. I then created a BAT file that I run using the task scheduler:

   set oracle_sid=pepe
   blat c:\tablespace_usage.txt -s "Daily tablespace report for PEPE on DEVDATA"
        -t myname_at_company.com -f PEPE_on_DEVDATA_at_company.com    exit

When the scheduled task runs, it hangs and the cmd process is taking up about 70% of the CPU resources. After ten minutes I killed the process using task manager.

Any idea what I'm doing wrong?

This is 8.1.6.1.2 on Win2k.

Thanks,
Helmut

> -----Original Message-----
> From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Jeff Cox
> Sent: Friday, October 27, 2000 10:51 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle NT Automatic mailing
>
>
> Saroj,
>
> I know of one easy (and FREE!!) way to do what I think you are
> looking for.
> It is not complicated, takes a short time to set up, and although it has
> no bells and whistles, it does exactly what I need it to do. It
> is using a
> product called BLAT. You can download it for free at
> http://gepasi.dbs.aber.ac.uk/softw/Blat.html
>
> You will be able to send e-mail using the WinAT scheduler and Blat by
> following the instructions below:
>
> 1. Copy the file Blat.exe to your \WINNT\SYSTEM32 directory, or to any
> other directory in your path.
>
> 2. At a DOS command prompt type: Blat -install yourhost.site.blah.blah
> youruserid_at_site.blah.blah, where yourhost.site.blah.blah is the
> address of
> your SMTP server and youruserid_at_site.blah.blah is the default From:
> address.
>
> 3. Make a batch file containing a command similar to the one below:
>
> blat export.log -s "Subject line of e-mail blah blah" -t
> jeff.cox_at_ips-sendero.com, jane.doe_at_oracle.com -f orabackup_at_ips-sendero.com
>
> list the file that you want to send, right after blat, and the
> contents of
> that file will appear in the e-mail (in my example, export.log)
> -s is what you want the subject of the e-mail to say
> -t is for who you wish to send the e-mail to
> -f will be who the e-mail is from.
>
> In the batch file, set the ORACLE_SID before the blat command or
> you might
> bump into a some issues.
>
> 4. Schedule WinAT to run the batch file after your backup process is
> finished and it will e-mail the log files to whomever you choose
> automatically.
>
>
> Let me know if you would like any assistance.
>
>
> Jeff Cox
> IPS-Sendero
> Scottsdale, AZ
>
>
> ----Original Message-----
> From: Dash, Saroj (CAP,CEF) [SMTP:Saroj.Dash_at_gecapital.com]
> Sent: Thursday, October 26, 2000 7:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle NT Automatic mailing
>
> In Oracle database the backup scripts are in NT scheduler,after running
> those scripts(Late night) in a batch automatically ,
> I want to send mails from NT scheduler to the corresponding person.
>
> Please tell me how can i do it.Please tell me the steps to do.
>
> Saroj.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jeff Cox
> INET: jeff.cox_at_ips-sendero.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Tue Oct 31 2000 - 13:57:44 CST