We recently experience that the scheduler seems to open a workbook for every scheduled task. The strange thing is that this workbook is not visible in excel and not even visible when closing excel. But, when I want to shutdown the pc, the system returns the question if I want to safe the changes in Book 2, 3 etc. The system was shutdown and restarted to make sure no other "forgotten" excel file was open and it was the same story. Running 10 scheduled tasks results in 10 workbooks to be closed when closing down the pc.
We use Jetreports 7.1.2 on Navision 5.0. and Windows XP
Anybody any clues?
Best regards,
Arnoud Rottinghuis
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi Arnoud,
Jet Reports definitely does open a workbook when you are scheduling a task. Namely, Jet Reports opens the workbook you are scheduling so that it can extract the named ranges from it to allow you to choose named ranges for things like updating the report options. However, the way this happens has changed somewhat from Jet Reports v7 to Jet Reports 2010. I would recommend you upgrade to Jet Reports 2010 and if the problem persists, create a ticket on our support site.
Regards,
Hughes -
Jet Reports Historic Posts Just an observation 2010 still will pop a workbook that disappears when yoo're in scheduling or if you happen to schedule reports to run while you are using workstation and you have excel open you may ( doesn't seem to happen everytime) have a workbook open and close on your desktop ( spooky :o )
Oh and if you check task master there is a copy of excel there for every workbook that scheduler has open. So in my case I have users who have anywhere from 2 to 8 schedules running nightly - some of which tend to overlap - some are by directory some individual sheets so it's not unusual for there to be anywhere from 2 to 6 copies of excel showing in task manager even with 2010.
Two things I've learned to do on users running scheduler before shutting down or even logging off -
check task master for running excel - check scheduler for running tasks
If you log off or shutdown and either of those caese are true Windows complains -
Jet Reports Historic Posts Hmmm, that is strange. Jet Reports should be killing the Excel process it uses to read named ranges (when you are scheduling the task) and also AutoPilot should kill the Excel process when it is finished running a scheduled task. Of course if there were overlapping scheduler tasks that were still running, then there would be an Excel process for each of them while they are running, but those Excel processes should disappear after they finish running.
Regards,
Hughes
Please sign in to leave a comment.