For eMessage only: Creating stored procedures, staging tables, and indexes
After you install or upgrade reporting templates, you must run specific SQL scripts before you generate eMessage reports. The SQL scripts create stored procedures and staging tables.
About this task
- acer_indexes_dbname.sql
- acer_tables_dbname.sql
- acer_scripts_dbname.sql
Run the following scripts against the Campaign database in the order listed.
Procedure
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 For eMessage only: How to schedule and run stored procedures.