Re: nt script

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).