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