Oracle-L: RE: nt script

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Fri, 07 Mar 2003 10:49:03 -0800
Message-ID: <F001.005638D6.20030307104903@fatcity.com>

I have found http://www.calweb.com/~webspace/batch/index.htm <http://www.calweb.com/~webspace/batch/index.htm> to be useful.

Raj

Rajendra dot Jamadagni at espn dot com
Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !!

-----Original Message-----
Sent: Friday, March 07, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L

Can anyone recommend a book / website on the DOS batch file language? I usually try to install cygwin and write shell scripts but some of our database servers don't have cygwin.

For example, I have no idea what this statement does: FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B and when I tried it I received an error H:\>FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B %%A was unexpected at this time.

> -----Original Message-----
> From: Jose Luis Delgado [ mailto:joseluis_delgado_at_yahoo.com
<mailto:joseluis_delgado_at_yahoo.com> ]
>
> I'll try to help you between lines...
>
> i.e. I'll write the corresponding CMD line for your
> script.
>
> Regards!
> JL
>
> in a .CMD file:
>
> > echo Sending mail!!!
> echo Sending mail!!!
>
> > dt=$(date '+%H%M_%m%d%y')
> FOR /F "TOKENS=1,2*" %%A IN ('DATE/T') DO SET DATE=%%B
>
> > export ORACLE_SID=FMRPT
> SET ORACLE_SID=FMRPT
>
> > sqlplus / <<EOF! > sqllog
>
> in a file: say a.sql put the code of your query and
> type:
>
> sqlplus user/password_at_instance < a.sql > sqllog.log
>
> > set heading off
> > SELECT 'FMRPT PSNTRP02 SCHEDULER DOWN' FROM DUAL
> > WHERE EXISTS (SELECT 'X' FROM PSSERVERSTAT
> > ...
> > ...
>
> > cat sqllog |egrep 'DOWN' > errfilelog
>
> type sqllog.log | findstr 'DOWN' > errfilelog.log
>
> > cat sqllog | egrep -q 'DOWN'
>
> I apologize for the previous line, I could not find a
> -q parameter of the egrep command, in my OS.
> anyway... 'guessing'
>
> type sqllog | findstr -<look the apropiate cmd> 'DOWN'
>
> > if [ $? -eq 0 ] # found at least one
>
> if errorlevel 1 <your_mail_program_here>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

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: ListGuru_at_fatcity.com (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).



text/plain attachment: ESPN_Disclaimer.txt

Received on Fri Mar 07 2003 - 12:49:03 CST