I've been seeing scheduled Jet reports running significantly longer than running by hand inside of Excel.
With all the ones I've tried, it's 10-20 times as long to run it through the scheduler.
These are connecting to NAV, and sending email as Excel values. There are no parameters.
For example, if I run one myself inside of Excel, it takes 3 minutes. With the scheduler, it took over 60, and this is consistent.
From what I can tell in SQL Profiler, the queries are firing off within the first few minutes, and then apparently finishing, so the last 57+ minutes are spent doing something else.
Are there any logs or debugging steps I can take to figure out what's taking these reports so long to complete and send?