Hi,
I have a scheduler code which starts a session on the BO Server, gets the report and then logs off. This process of opening and terminating session itself takes about 6-9 seconds of entire reports execution time (which is approx 15 u2013 20 seconds). So, for processing around 2000 reports , it causes server performance degrade.
Please can anyone suggest a method by which once a session is started instead of shutting it down, it should be reused for the next scheduled reports. Meanwhile it needs to be considered that not too many sessions are opened during parallel refresh causing server performance degrade.
Please anyone suggest on the same.