Very slow reports with AutoPilot

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?


1 comment

Please sign in to leave a comment.