Waiting for executions before starting a processTutorial
How to Create a Data Provider Command Package to Wait for Another Job to FinishCreating a Data Provider Command Package to Wait for Another Job to FinishWhen 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 GuideCreate a Package > Data Provider Command Select the Data Governance Data Provider and Custom SQLCustom SQL CommandUse 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 groupsDECLARE @end_date DATETIMEWHILE 1=1BEGIN SELECT @end_date = end_date FROM reporting.execution WHERE task_id = @t