I've never tried myself, but wouldn't it be easier to just write something quick in Python that runs your existing tool, instead of trying to convert everything to Python?
Does this help? Not sure what flavour of Spatial ETL tools you're running.
Once the Python is written, just have your Windows Task Scheduler call the Python file at whatever interval/time frame you choose.
Thanks. I found this and I am trying to have a similar simple python script.
Run your ETL tool and from the results window right click the result and copy it as a Python snippet.
Then create a standalone Python script that imports arcpy and imports the toolbox, before executing the snippet, like:
I will let you know if this works for me.
Be sure that you're running the 32 bit Python executable. I have a batch file that calls this version, then my script like below:
Otherwise, I'd receive a "AttributeError: 'module' has no attribute when calling Spatial ETL tool" error.