We are a large health care system and run approximately 1600 reports on the first work day of each month. One of our issues is long running reports tying up the system preventing other reports from running and report timing.
Some reports need to run before all others so that upper management can have the data they need early is the day. One of the questions is how can we schedule the reports we need first to run first.
Another item that confuses us is why the start times of the reports different when the submit time is the same. Is this caused by the length of time reports take to run?
Any thoughts on this issue would be appreciated. I'm sure I will have other follow up questions.