Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Scheduling Reports to Run at specified time
Use R25RUN in batch mode (something like):
c:\orant\bin\r25run report1 userid='user/password_at_database' batch=yes
Put that line in a DOS batch file or cmd file. On a Windows NT Server you can use the DOS AT command to schedule.
I'm sure their are plenty of ways to schedule running of a batch file that I'm not aware of.
Happy Reporting!
Mick Cooke wrote in message <7tkoia$omk$1_at_grind.server.pavilion.net>...
>Oracle 7.3.3.0.0 NT4 SP3
>Developer 2000 Reports 2.5
>
>I am VERY new to Reports and have created number of reports that I need to
>run at specific times overnight.
>Is there any facility either in developer 2000 or Oracle that I can use to
>schedule reports to run?
>I believe DBMS_JOBS will enable the scheduling of procedures and PL/SQL
code
>would it be possible to create a report
>to spool to a file from within a procedure?
>
>Thanks in advance
>Mick
>
>
Received on Fri Oct 08 1999 - 22:07:39 CDT
![]() |
![]() |