RE: nt script

Don't run it line by line
Save it to a file called myfind.bat

Then call from a command prompt

C:\> myfind.bat

Or click the batch file, be sure to leave the pause so you can see an error if any. Once its working, you can then implemet blat as someone suggested

Here is a version using variables

##########################################################

[myfind.bat]
:: Find example by BMetelsky on Friday-April-11-2003-9:22:53 AM :: This script searches thefile for a string and if it finds it, sends an email message to dbamail
:: 0 =is found
echo off
set themess=A Database SERVICE on %computername% is NOT running on %date% at %time%
set [EMAIL PROTECTED]
set blatfile=D:\dbmon\blattext.txt
set thefile=D:\dbmon\runit.log
set subject=A DB SERVICE IS NOT RUNNING
set [EMAIL PROTECTED]
echo starting >%blatfile%

find "ERROR:" %thefile% >NUL

IF ERRORLEVEL 1 GOTO no
IF NOT ERRORLEVEL 1 GOTO yes
:no
goto end

:yes
echo A db service is down on %computername%>%blatfile% blat D:\dbmon\blattext.txt -subject "%subject%" -to "%dbamail%" -i "%from%" -body "%themess%"
goto end

:end
@exit
rem echo %errorlevel%

##########################################################

> Hi Bob, thanks for the reply. I added your code and tested
> still no good. I tested the case without a match. Still go to run.
>
> Joan
>
> D:\oracle\admin>FORFILES
> -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log -d+0 -c"CMD
> /c echo @FILE" PSPRCSRV_PSNT_0630.log PSPRCSRV_PSNT_0701.log
>
> D:\oracle\admin>echo on
>
> D:\oracle\admin>FORFILES
> -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log -d+0 -c"CMD
> /c type d:\pslog [EMAIL PROTECTED]|findstr ORA-03113
> >D:\oracle\admin\test.log"
>
> D:\oracle\admin>rem FORFILES
> -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log -d+0 -c"CMD
> /c type d:\p [EMAIL PROTECTED]|findstr ORA-03113" >NUL
>
> D:\oracle\admin>IF ERRORLEVEL 1 GOTO no
>
> D:\oracle\admin>IF NOT ERRORLEVEL 1 GOTO RUN_PROC
>
> D:\oracle\admin>rem d:\psfm\start_proc_sched.bat
>
> D:\oracle\admin>echo run
> run
>
> D:\oracle\admin>pause
> Press any key to continue . . .
>
> D:\oracle\admin>goto end
>
> D:\oracle\admin>echo "finished"
> "finished"
>
> D:\oracle\admin>rem if errorlevel 1 @d:\psfm\start_proc_sched.bat
>
> Bob Metelsky wrote:
> >
> > echo off
> > @cls
> > find "ORA-124" C:\yourlog.txt >NUL
> >
> > IF ERRORLEVEL 1 GOTO no
> > IF NOT ERRORLEVEL 1 GOTO yes
> >
> > :no
> > ECHO NOT FOUND
> > goto end
> >
> > :yes
> > ECHO String IS found
> > pause
> > goto end
> >
> > :end
> > exit
> >
> > >
> > > Hi listers,
> > >
> > > I am working on a nt script. I download FORFILE exe, it
> works fine.
> > > My intention is finding the ORA-03113 string in the log.
> If there is
> > > a match, then reboot the server, else do nothing. I don't have
> > > problem with the findstr part. However, the errorlevel
> always return
> > > 0, no matter it find the error or not. So the if statement is not
> > > working. Can somebody give me some light on NT syntax? On
> unix, it
> > > is so easy to script the condition. Please help,
> > >
> > > Thanks,
> > >
> > > Joan
> > >
> > >
> > > FORFILES -pd:\pslogs_psfm\fmdev8\_psprcsrvlog\ -s -m*.log
> > > -d+0 -c"CMD /c type
> > > d:[EMAIL PROTECTED]|findstr ORA-03113" if
> > > errorlevel 1 goto run_proc echo 'there is a match'
> > >
> > > if errorlevel 0 goto end
> > > echo 'there is no match'
> > >
> > > :run_proc
> > > d:\start_proc.bat
> > > goto end
> > >
> > > :end
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > > --
> > > Author: Joan Hsieh
> > > INET: [EMAIL PROTECTED]
> > >
> > > Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> > > San Diego, California -- Mailing list and web
> hosting services
> > >
> --------------------------------------------------------------------
> > > -
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: [EMAIL PROTECTED] (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 also send the HELP command for other
> > > information (like subscribing).
> > >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Bob Metelsky
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web
> hosting services
> >
> ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: [EMAIL PROTECTED] (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
> also send
> > the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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 also send the HELP command for other
> information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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
also send the HELP command for other information (like subscribing).