If you’re using Jet Hub with Jet Reports, then when you run a report, the report run is stored in the Jet Services database;through time, this report run history can grow quite large if you either have large reports or are generating lots of reports; combine these together and the history can grow to potentially massive sizes.
Jet Hub does not, unfortunately, include an automated clear-down…
Continue Reading Ian Grieve’s Article on their blog
SQL Stored Procedure to remove Jet Reports’ Report Run History
If you’re using Jet Hub with Jet Reports, then when you run a report, the report run is stored in the Jet Services database;through time, this report run history can grow quite large if you either have large reports or are generating lots of reports; combine these together and the history can grow to potentially massive sizes.
Blog Syndicated with Ian Grieve’s Permission
More About This Author
Array
Dyn365GP2023.03.29New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Extensions That Fail Pre-Upgrade Validation Get More Detailed Error Insights- Dyn365GP2023.03.29New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Define Regional Settings Per Report Using a Region Property
- Dyn365GP2023.03.28New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Country/Regional Expansion – Andorra
Dyn365GP2023.03.28New Functionality In Microsoft Dynamics 365 Business Central 2023 Wave 1: Save Time With Automatic Account Codes (Sweden and Finland Only)
