Re: REPORT
From: peter <misybh_at_tpts7.seed.net.tw>
Date: 2000/08/08
Message-ID: <8mno6i$gfe_at_netnews.hinet.net>#1/1
> "peter" <misybh_at_tpts7.seed.net.tw> wrote in message
> news:8mgaiv$nlm_at_netnews.hinet.net...
> >
> > ±H¥óªÌ: peter <misybh_at_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_at_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.
>
>
>
>
Received on Tue Aug 08 2000 - 00:00:00 CEST
Date: 2000/08/08
Message-ID: <8mno6i$gfe_at_netnews.hinet.net>#1/1
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_at_no.email.address> wrote in message
news:8mmlsa$n07$1_at_taliesin2.netcom.net.uk...
> "peter" <misybh_at_tpts7.seed.net.tw> wrote in message
> news:8mgaiv$nlm_at_netnews.hinet.net...
> >
> > ±H¥óªÌ: peter <misybh_at_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_at_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.
>
>
>
>
Received on Tue Aug 08 2000 - 00:00:00 CEST