Report Scheduling Best Practices

Some best practices to consider when scheduling reports are as follows:

  • Avoid excessive reports and potential performance issues by planning for the report contents before submitting it to run. Choose the report design and filters appropriate to the required output.

  • For reports that run regularly, particularly large reports, where feasible, schedule them to run outside of the usual business hours.

  • When setting the schedule time, avoid regular maintenance times, when the server may be being taken down.

  • For reports that focus on data at a point in time, take into account that users who enter the data may have their working day in a different time zone.

  • Ensure other recipients of the report have permission to access the report and the data therein. Recipients will only be able to view the report output if they are a user of the system with access to the Report module.

    Note that other than any EAC Area restrictions, it is possible for a report to contain data that a recipient would not usually have access to when accessing Supplier Evaluation. For further details on the reporting permissions rules, see Appendix: Permissions.

  • Select the report output formats (typically Excel or PDF) that are appropriate to the report type and the recipients. Avoid choosing more formats than are necessary.

  • After submitting a report to run, avoid repeatedly resubmitting it while waiting for it to complete. Use the schedule monitoring facility (see Monitoring Scheduled Reports).

  • Where it is not necessary to retain previous versions of the report, use the option to overwrite existing report outputs rather than creating a new output each time the report is run.

  • Delete report outputs that are no longer required, rather than relying on the automated purging.

  • If historic copies of the report are required to be retained, save the report output to a local or network location rather than storing them within the system.