The WorkbenchInterface Database
- Former user (Deleted)
The WorkbenchInterface database is a separate database (part of the Report Scheduling setup) used to process the My Management reports before they are delivered to the My Management screens.
A Microsoft SQL Server SQL job is required to be running, on the Workbench database, at intervals less than the requirements of the panels. For example if a Panel requires a report to be run every hour, but the SQL job runs once per day, then the report on the Panel will only be rerun and updated once per day. The stored procedure to be executed in the SQL Job is wbCreateMyManagementReports. Greater detail on this is provided in the Report Scheduling manual, of which this process forms part.
There are 2 critical tables within the WorkbenchInterface database that you need to be aware of in relation to MyManagement reports:
DatabaseControl
This table contains the settings that tie the interface Database back to the Workbench Database. The DatabaseNo in this table must be the same as the SiteID in the Workbench Control table. This setup is covered in the Report Schedule manual
ReportQueue
Contains the details of the reports delivered by MyManagement Panels and the status of delivery and any error messages. This is particularly useful if you are troubleshooting as to why a report has not been delivered to the MyManagement screen.