For eMessage reports, creating stored procedures, staging tables, and indexes
Before you render eMessage reports, run specific SQL scripts after you install or upgrade reporting templates. The SQL scripts create stored procedures and staging tables.
About this task
- acer_indexes_
dbname
.sql - acer_scripts_
dbname
.sql - acer_tables_
dbname
.sql
Procedure
Complete the following steps to run the database scripts:
What to do next
Note: You must configure the stored
procedures to run on a regular basis to populate the staging tables.
You cannot see data in the reports until you run the stored procedures
for eMessage reports.
For more information about running and scheduling the stored procedures, see Running and scheduling stored procedures for eMessage.