Agresso help and temp tables


Job details

Name: Agresso help and temp tables
Platform: Sqlserver
Category: Agresso
Description: Collects information about objects (temporary tables and help tables) created in the agresso application schema.
Long description: Collects information about objects (temporary tables and help tables) created in the agresso application schema.
Version: 1.31
Default schedule: 30 6 2,6 *
Requires engine install: Yes
Compatibility tag: .[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2012′ & hasengine=‘YES’ & (engine_edition = ‘Microsoft SQL Server’ engine_edition = ‘Azure SQL Managed Instance’)]

Parameters

Name Default value Description
database name agr% The name of the agresso database. You can specify a list of databases (separated by comma). You can use % (percent sign) to represent wild card characters.
Help tables prefix agr% Prefix used by the Agresso help tables created when running Agresso reports.
Temporary tables prefix H% Prefix used by the temporary tables in the Agresso schema.
warning threshold — total size 1000 Warning threshold, in MB, for aggregated size value for all help and tmp tables.
warning threshold — total count 1000 Warning threshold for total count value of all help and tmp tables.
history threshold 366 The number of days the statistics will be kept in the history table.
max databases per graph 5 The maximum number of databases visualized in the report graphs.

Job Summary

Job Description

Key Features

Technical Implementation

Outputs and Reports

Dependencies and Parameters

Specified dependencies for this job include:

Description Object Cleanup Required
Self Dependency agr_help_tabs_check Yes
Current statistics agr_help_tabs_schemas_curr Yes
Historical data table agr_help_tabs_schemas_histr Yes

Parameters configured for threshold management include:

Version and Compatibility

Implementing and monitoring such jobs is crucial for database administrators to ensure optimal performance and to avoid potential issues related to database size and schema complexity. This job provides a useful blend of automation and manual intervention points for effective database management.