Bob, I tested it out, it works on one hard code file. If I set thisfile it works. But in reality, I need to find today's log, the log file name convention is always goes psprcsrv_psnt_0701.log with the date suffix to the end. I can't hard code the file name in the bat file. Is there anyway how to get around with this?
Thanks, Joan Bob Metelsky wrote: > > 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). -- 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).
