Overview
When using Managed Thread Execution, Jet Data Manager (JDM) automatically prioritizes the order in which objects are executed. The execution order is determined by an internal dependency algorithm setup that evaluates the relationships and data structures defined within your project.
Jet Data Manager considers several project structures when calculating dependencies, including:
Relations between tables (type Warning and Error)
Conditional Lookup Fields
Data Movements to the Data Warehouse
Table Inserts
Add Related Records
However, dependencies can sometimes exist in custom views or script commands that aren’t automatically detected. To handle these, you can manually define dependencies on any table, cube or dimension.
Manual dependency setup ensures that objects referenced within custom views or scripts are processed in the correct order, allowing for a more optimized and reliable execution package. Learn how to setup service dependencies in JDM Scheduler: SQL Server Dependency in Jet Data Manager Scheduler.
Important Notes
Dependencies in script actions and in views without parameters are not handled automatically.
Dependencies in views with parameters are handled automatically by Jet Data Manager.
Process: How to Define Object Dependencies?
Right-click the object for which you want to define a dependency.
Navigate to Advanced > Object Dependencies.
In the Object Dependency setup window, select the objects that the current object depends on.
Click OK to save and set the dependency.
Once defined, Jet Data Manager will consider these additional dependencies during execution, ensuring that all prerequisite objects are processed before the dependent ones.
Why Manual Dependencies Matter?
Manually defining dependencies helps:
✅ Ensure correct execution order when custom scripts or views are used.
✅ Improve project reliability and prevent data load issues.
✅ Optimize performance in complex ETL projects.
Conclusion
Properly setting up Object Dependencies in Jet Data Manager gives you greater control over execution flow and data processing. By combining automated and manual dependencies, you can maintain efficient, error-free project execution across all environments.
