Any tips for Extract & Transform running .bat files

[rustyfishbones]

Hi All,

I have an Extract file and a Transform file that I have created 2 bat files to reload the Data Store QVD's etc

Any tips on how best to schedule these to run on the Windows Task Scheduler?

Regards

Alan

[alexandros17]

Use TrafficLights logic, that is when a task start create a file then at the end delete it. If the next task finds that file, something has gone wrong ...

[rustyfishbones · Accepted solution]

I have this sorted, need to run whether user is logged on or not

And then on the triggers tab make sure the below radio button is ticked

The files will reload no problem, even if the user is not logged on