Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> How do I automatically pass the date parameters?
I have created a report using the reports builder (on NT 4.0) which I am able
to run from the command line successfully. Now, I want to automate this to
run every night -which I can again do using the NT schedule Task to run a DOS
batch program I created containing the r30run32 command. My problem is - I
pass 2 parameters Date_from & Date_to to the report which should
AUTOMATICALLY take the values (7 days from today) and (yesterday)
respectively (i.e in oracle (sysdate-7) and (sysdate-1)). I am at a loss of
how to do this in a DOS batch file. Can somebody shed some light??
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 14 1999 - 18:04:26 CDT
![]() |
![]() |