RE: Problem with BLAT; was: Oracle NT Automatic mailing

Helmut,

I set the SID in my .bat file because I was also running an export command, and then BLAT would e-mail me the export log file. If you are trying to execute any Oracle commands in the bat file without setting the SID, WinAT might crap out on you.

If you are not executing any Oracle commands in the .bat file, there is no need to set the sid in it. Are you trying to execute any commands other than: 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 ???

It should take less than a second to send the e-mail. Can you send an e-mail on the same machine via Outlook or some other app?

Jeff

-----Original Message-----

From:	Helmut Daiminger [SMTP:hdaiminger_at_vivonet.com]
Sent:	Tuesday, October 31, 2000 12:58 PM
To:	ORACLE-L_at_fatcity.com; jeff.cox_at_ips-sendero.com
Subject:	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? Received on Tue Oct 31 2000 - 07:36:07 CST