--- title: Create An Execution Package description: "## Overview   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.   ### Creating…" url: "https://globaldata365.com/helpcenter/create-an-execution-package/" updated: "2026-10-25" category: Jet Analytics tags: - jet analytics - OLAP cubes --- # Create An Execution Package ## Overview   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.   ### Creating a Notification   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.   - Using the **Solution Explorer **open the **Execution **tab, right-click **Notificatio****ns,** and then select **Add****Notificati****on.** ![execution package](https://globaldata365.com/wp-content/uploads/2022/11/Screenshot-25.png) A window will appear with the following settings: ![](https://globaldata365.com/wp-content/uploads/2022/11/image-2.png) - In the **Name **field, type a name for the notification. - In the **Type **field, select the type of notification you want to create. You have the following options. | **Option** | **Description** | | --- | --- | | Mail | Creates an email notification | | Event Log | Writes a notification to the event log | | Both | Creates both an email notification and writes to the event log | 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. - In the **From **email field, type the email address using which you want to send the notification from. - In the **To **email field, type the email address you want to send the notification to. - In the **Cc **field, type the email address you want to send a copy of the notification to - In the **Subject **field, it is possible to use parameters in order to define the subject of the email.  The accepted parameters are: | **Parameter** | **Description** | | --- | --- | | %Project% | Inserts the name of the project | | %Status% | Inserts the status of the execution package (Success/Fail) | | %ExecutionPackage% | Inserts the name of the execution package | - Check the box **Enable SSL/TLS** if required. - Check the box **Allow Invalid Certificate**, if an invalid SSL certificate has to be trusted. - Click **OK** The notification can now be selected when you create an execution package. **Want to turn raw ERP data into powerful business insights?** [👉 Join our Jet Analytics Training](https://globaldata365.com/jet-analytics-training/) and master building data warehouses, cubes, and advanced dashboards. ### Creating an Execution Package   An execution package determines the elements of a project which will be executed.   - Using the **Solution Explorer **open the **Execution **tab, right-click **Execution****Pa****ckages,** and then select **Add Execution Package**. ![execution package](https://globaldata365.com/wp-content/uploads/2022/11/Screenshot-26.png) - Type a name for the **Execution Package** in the **Name** field. - Click and drag the **Execute Project **level from the **All Steps **tree on the left and drop it in the **Selected Steps **window on the right. ![execution package](https://globaldata365.com/wp-content/uploads/2022/11/a-2-894x1024.png) - In the **Action **field, specify the action to perform if the execution fails. You have the following options: ![execution package](https://globaldata365.com/wp-content/uploads/2022/11/b-1-1024x120.png) | **Option** | **Description** | | --- | --- | | FailPackage | Cancels the execution in case of failure | | RetryStep | Executes the package again in case of failure |   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:   - From the **Notification on Success / Notification of Failure**section,** **select the notification to use when the execution package succeeds or fails. In this example we are only being notified if the execution package fails. ![execution package](https://globaldata365.com/wp-content/uploads/2022/11/image-3-1024x140.png) - In the Managed Execution drop-down, select a managed execution method. When enabled the execution package will be managed internally, meaning the application will decide the order in which objects are executed based on dependencies and the degree of parallelism specified by the Max Threads setting. You have the following options: ![](https://globaldata365.com/wp-content/uploads/2022/11/image-4.png) | **Option** | **Description** | | --- | --- | | Disabled | No managed execution will take place. | | Execution Number | Based on the order of the objects in the project tree. The higher in the tree the sooner the execution. | | Classification | The JDM will choose the order of objects based on their table classification: The order will be 1) Fact Table - Large 2) [Dimension](https://globaldata365.com/helpcenter/creating-measures-dimensions-and-cubes/) Table - Large 3) Fact Table 4) Dimension Table If two tables have the same classification the JDM will use the Execution number as the secondary Criteria. | | Execution Time | The JDM will choose the object based on the average historical execution time for the object. If two objects have the same average execution time (i.e., new objects), then the JDM will use Execution Number as the secondary criteria. | - Select the maximum number of tasks for the JDM to run in parallel, using the **Max Threads** box. ![](https://globaldata365.com/wp-content/uploads/2022/11/image-5.png) ### Specify an Execution Schedule   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. - Using the **Solution Explorer **open the **Execution **tab, right-click the **Execution Package **to which you want to add a schedule and select **Add****Schedule.** ![](https://globaldata365.com/wp-content/uploads/2022/11/Screenshot-28.png) The following window will appear: ![](https://globaldata365.com/wp-content/uploads/2022/11/ss.png) - Click the **Daily **radio button. - The **Frequency **option will allow the user to set the time during which you want to execute the project throughout the day. This will run the execution at a specified time period. - In the **Start time **field, enter the start time of the time interval. - In the **End time **field, enter the end time of the interval. - In the **Run every **field, specify the number of hours and minutes between each project execution. ![](https://globaldata365.com/wp-content/uploads/2022/11/ss2.png) - The **Specified Hours **option will allow the user to select the exact time at which the package will be executed. - If using **Specified****Hours,** enter the exact time for the execution to run and then click **Add****T****ime.** The example above will run the package at 10:00AM and 2:00PM. - Select **Enabled **to activate the schedule, and then click **O****K.** ### Committing Execution Package Changes   The following message appears after modifying an execution package. ![](https://globaldata365.com/wp-content/uploads/2022/11/image-6.png) 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**. ![](https://globaldata365.com/wp-content/uploads/2022/11/Screenshot-29-1-1024x581.png)   ####   ###### Still have Questions? Ask us anything about this article – we’ll get backto you shortly.