Re: REPORT
Date: 2000/08/07
Message-ID: <8mmlsa$n07$1_at_taliesin2.netcom.net.uk>#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
[Quoted] obviously optional). This creates the output in portable document format
(use Adobe Acrobat Reader to display/print). Note the %1 means use the first
[Quoted] 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 [Quoted] 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 [Quoted] want, and then you won't need to pass it in as a parameter.
Carl. Received on Mon Aug 07 2000 - 00:00:00 CEST