From: "peter" <misybh@tpts7.seed.net.tw>
Subject: Re: REPORT
Date: 2000/08/08
Message-ID: <8mno6i$gfe@netnews.hinet.net>#1/1
References: <8mgaiv$nlm@netnews.hinet.net> <8mmlsa$n07$1@taliesin2.netcom.net.uk>
Organization: DCI HiNet
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Newsgroups: comp.databases.oracle.tools


hi... THANKS FORyour reply.....   how to send a email automatically to me if
my .batch  jog is finished??
if the .BAtch run correctly,I wish i can receive  a email which content
contains "every thins is good" otherwise  "ERROR......." such a string...
how to do that????My mail system is LOTUS NOTES R5....

thanks for your reply..

Carl Heaton <sorry@no.email.address> wrote in message
news:8mmlsa$n07$1@taliesin2.netcom.net.uk...
> "peter" <misybh@tpts7.seed.net.tw> wrote in message
> news:8mgaiv$nlm@netnews.hinet.net...
> >
> > ±H¥óªÌ: peter <misybh@tpts7.seed.net.tw>
> > ¥D¦®: developer 2000 v 2.1
> > ¤é´Á: 2000¦~8¤ë4¤é PM 08:25
> >
> > hi..
> >           how to run a report  daily....
> >           my system is NT workstation ,can I use nt command 'AT'
> >           to write a batch file (run this report at mid-night)?
> >
> >          How to do this?
> >
> >
> Peter,
>
> We do this using a 'batch' file (NT script) containing something like this
> :-
>
> R25RUN32.EXE USERID=%1 MODULE=<path>/<xxx>.rep
> USER_PARAM1=abc USER_PARAM2=xyz
> PARAMFORM=NO DESTYPE=FILE DESFORMAT=PDF
> DESNAME=<path>/<output_name>.PDF
> PRINTJOB=NO NONBLOCKSQL=NO BATCH=YES
>
> (Note the above command must all be on one line. User-defined parameters
 are
> obviously optional). This creates the output in portable document format
> (use Adobe Acrobat Reader to display/print). Note the %1 means use the
 first
> parameter supplied to the batch script when it's executed.
>
> In NT your "schedule" service must be started up (see control panel ->
> services), then use a command like the following to run the above .BAT
 file
> on a regular basis :-
>
> AT 00:00 /interactive /every:M,T,W,Th,F <path>/<above_file>.BAT
> user/pass@dbname
>
> You could 'hard-code' the Oracle username/password into the .BAT file if
 you
> want, and then you won't need to pass it in as a parameter.
>
> Carl.
>
>
>
>