Configuring the Scheduled Reports Database List - On-Premise only
Updated
by
Cheryl Wallace
For On-Premise installations only where the ToolHound database is on a shared SQL Server, the databases polled for scheduled reports can be restricted if desired. The normal process for scheduled reports is to poll each database accessible by the SQL User in the connection string to validate whether it is a ToolHound database. If the user does not have access to other databases, this is not a concern.
To configure the list of databases to be polled for scheduled reports, add the DatabaseList parameter to the ScheduledReports block in the appsettings.json file. The appsettings.json file is found on the application server in the installation path.
Example: single ToolHound database:
"ScheduledReports": { "RunService": true, "IntervalInMinutes": 120, "Process": true, "DatabaseList": "OleanderTH6" }, |
Example: multiple ToolHound databases:
"ScheduledReports": { "RunService": true, "IntervalInMinutes": 120, "Process": true, "DatabaseList": "Production,Test" }, |
. See also:
Copyright © 2020-2022 ToolHound Inc. All Rights Reserved.