RE: nt script

Write your daily file to a 'nodate' file. Then copy it to a date file for backup. Run your script against the 'nodate' file.

Ron

-----Original Message-----
Sent: Tuesday, July 01, 2003 2:51 PM
To: Multiple recipients of list ORACLE-L

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).
If you are not the intended recipient of this e-mail message, any use,
distribution or copying of the message is prohibited.  Please let me know
immediately by return e-mail if you have received this message by mistake,
then delete the e-mail message. Thank you.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Smith, Ron L.
  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).