Re: nt script

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