0
1
I'm looking for some direction in scheduling sequential tasks within Windows Scheduler. The tasks in this instance are workflows that kick off data ETL and incremental load jobs. We want to only initiate subsequent tasks in which prior tasks have been finished. Any help would be greatly appreciated.
Thanks!!
Whit
Posted 2019-01-30T20:23:10.743
Reputation: 1
0
You can create a multi-step task in Windows Task Scheduler, but all steps will run when the task triggers. (You can use Start /Wait ... to get each step to wait until finished before handing off to the next step, if that's all you need. But if you need to abort the whole set if one step fails, you'll need more granularity than Task Scheduler.)
Your other option is to make the Windows Task Scheduler kick off a single batch file or Powershell script that will then handle the rest. The batch file or Powershell script can then kick off your first task, wait for the result, and then decide what to do next.
Doug Deden
Posted 2019-01-30T20:23:10.743
Reputation: 1 568
Thanks Dog for your response!! I have another slight nuanced scenario. So we have two parallel tasks running and then we have a child tasks that is DEPENDENT on both the parallel tasks completing. How would you configure something like that? And also for future scenarios in which there could be 3,4 parallel parent tasks that future tasks will depend on. Thanks for your help. – Whit – 2019-01-31T21:32:22.410
If running the tasks in series is an option, you can use
Start /Wait ...for that. But if they have to run in parallel, and a future task has to be delayed until both parallel tasks finish, you'll want to use something with more flexibility than the Windows Task Scheduler. A batch file or PowerShell script can start the parallel tasks, keep track of their successes or failures, and then decide if and when to start the following task or tasks. – Doug Deden – 2019-01-31T22:44:07.857