Thanks Seefelt, I need to get the most recent log to check. There are more than 30 logs on that directory. I just check the most currenct one. That's why I use d+0 still it give me 2 files. Is there any way I can just get one file?
Jon "Seefelt, Beth" wrote: > > Hi, > > I think FORFILES is probably overkill here. And it probably is only > going to return the errorlevel for the last file checked. Just use > FINDSTR with a wildcard. > > FINDSTR /S /I /L "ORA-03113" d:\pslogs_psfm\fmdev8\_psprcsrvlog\*.log > 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 > > HTH. > > -----Original Message----- > Sent: Tuesday, July 01, 2003 12:15 PM > To: Multiple recipients of list ORACLE-L > > 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: Seefelt, Beth > 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).
