Waiting for executions before starting a processTutorial
How to Create a Data Provider Command Package to Wait for Another Job to Finish Creating a Data Provider Command Package to Wait for Another Job to Finish When working with data processes in TimeXtender Data Orchestrator, there are instances when you may need to wait for an unrelated job to complete before initiating another process. In such cases, you can create a Data Provider Command package that ensures the second process starts only after the first job finishes. Step-by-Step Guide Create a Package > Data Provider Command Select the Data Governance Data Provider and Custom SQL Custom SQL Command Use the following SQL command to create the wait mechanism: DECLARE @task_id int = 123 -- the task id of the schedule groupDECLARE @task_type varchar(20) = 'EBI_PACKAGE' -- the type of the object you are running within the schedule group, as we cannot wait for schedule groups DECLARE @end_date DATETIME WHILE 1=1BEGIN SELECT @end_date = end_date FROM reporting.execution WHERE task_id = @task