Execution packages are used to update the staging database, data warehouse, and OLAP cubes on a scheduled basis.
You can also set Notifications to alert specified individuals when the execution package has successfully run.
Notifications are set to alert specified users whether the execution package has run successfully or failed to execute. These notifications are set up as email alerts but can be saved to the Event Log as well.
A window will appear with the following settings:
Type the name of the mail server you want to send the email from, using the Mail Server Name field. In order to maintain a secure server, you can enter a specific Port as well as a User Name and Password.Note: SMTP is currently the only supported email method.
The notification can now be selected when you create an execution package.
An execution package determines the elements of a project which will be executed.
You can specify in the Retries field how many times you want the execution package to restart, and then in the Wait field you can specify the number of minutes to wait before retrying again.
Projects can be executed at different times depending upon your schedule. When you specify an execution schedule, the execution process is started automatically at the specified time.
The following window will appear:
The following message appears after modifying an execution package.
To commit the changes we must save the project as a deployed version. To do this right click on the project name → Advanced → Save project as deployed version.