Scheduling reports

Instead of allowing users to refresh report data themselves, you may want to schedule reports to be run at a particular time (for example, hourly, daily, or weekly). This may improve system performance by drastically reducing the number report jobs for the Page Server.

For instance, suppose that a user routinely views three company reports. If these reports were refreshed each working day for a month, the Job Server would have to run 60 report jobs in total.

3 reports x 5 days x 4 weeks = 60 reports

Now let's suppose that there are 100 users who refresh these three reports every day for the same period of time.

60 reports x 100 users = 6,000 reports

However, if you were to schedule the three reports to run daily for four weeks, and you distributed these reports to 100 users instead of allowing each of them to refresh the reports themselves, only 60 reports would need to be run on the Page Server, reducing the number of report jobs by 99 percent.