Can we set the priority in Oracle Reports ? [message #231036] |
Fri, 13 April 2007 13:54 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rkhatiwala
Messages: 178 Registered: April 2007
|
Senior Member |
|
|
Can we set the priority in Oracle Reports ? Say, for example, we have scheduled weekly reports ( around 40 - 50 reports) that runs 1st of every month at 9AM. While these reports are still running , we want to run an adhoc report , which canbe for last one week. Can we set the priority such that adhoc report is executed first ? Or is it something like they both will run parallel in different sessions ?
Thanks.
|
|
|
|
Re: Can we set the priority in Oracle Reports ? [message #231334 is a reply to message #231036] |
Mon, 16 April 2007 10:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rkhatiwala
Messages: 178 Registered: April 2007
|
Senior Member |
|
|
May be I couldnt explain it clearly..
We have a batch job that runs 50 scheduled reports. Say, now 9th report is still running and an adhoc report is requested. what will happen then ?
1). will it finish all the 50 reports first, and then execute the adhoc as the 51st report ? -- not desirable
2). or will it finish the currently running 9th report and then execute the adhoc. When adhoc is done, then resumes the running of 10th scheduled report ? -- highly desirable.
3). or will it stop running the 9th report, and start running the adhoc report ? if so, then how to resume the 9th report ? -- not desirable
please help
|
|
|
Re: Can we set the priority in Oracle Reports ? [message #231367 is a reply to message #231334] |
Mon, 16 April 2007 15:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
It must be me and lack of English comprehension ... I apologize if it sounds insane, but let me try.
"Will it finish", "will it stop", ... - what is it? Is it a batch job? So, basically, you schedule 50 reports in a job and go out for a weekend. When you're back on Monday, you just collect reports' results and that's it. Right?
And sometimes you want to run a report which has nothing to do with a scheduled job. You don't even have to know which report runs at the moment. So, in order to run it, you connect to your application, select this particular report in a menu and run it.
I can't understand what would prevent you from doing this? Why do you have to take care about batch job progress? Scheduled reports will run in an order you told them to. Your standalone report can be run anytime.
Obviously, I'm incapable to figure that out and I'm sorry for not being able to help you, but - I don't see a problem here.
|
|
|