Message-Id: <10666.120731@fatcity.com> From: Jeff Cox Date: Tue, 31 Oct 2000 13:36:07 -0000 Subject: 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@company.com -f PEPE_on_DEVDATA@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@vivonet.com] Sent: Tuesday, October 31, 2000 12:58 PM To: ORACLE-L@fatcity.com; jeff.cox@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@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@company.com, retry 1 time(s) Then I tried it again: c:\>Blat -install mail.company.com PEPE_on_DEVDATA@company.com SMTP server set to mail.company.com on port with user PEPE_on_DEVDATA@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@company.com -f PEPE_on_DEVDATA@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?