Message-Id: <10666.120724@fatcity.com> From: "Helmut Daiminger" Date: Tue, 31 Oct 2000 11:57:44 -0800 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? This is 8.1.6.1.2 on Win2k. Thanks, Helmut > -----Original Message----- > From: root@fatcity.com [mailto:root@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@site.blah.blah, where yourhost.site.blah.blah is the > address of > your SMTP server and youruserid@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@ips-sendero.com, jane.doe@oracle.com -f orabackup@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@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@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@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