This page describes how to set up an E-mail that is sent to one or more mail accounts when the ETL process has finalized, reporting the status of the processing.
During installation of the Analysis Models an SQL Server Agent Job will be created that can be used to run the ETL process either manually or scheduled.
In both cases and especially in the scheduled case, it is of interest to know when the ETL transfer has finalized and what the status is.
A suggested option is to configure a database mail that is defined as an action if the SQL Server Agent Job.
The following steps are included:
All steps are described in a PDF document.
Since this is general functionality related to SQL Server, more details can be found on the net.