Hi Ben
It's been a while since I tried this on Foundation, but I believe Transaction scripts can't be setup to run on a recurring schedule, while query will.
This is an Evolve screen shot of Query runs - picking up the same template, but then append a datetime stamp to it every time it's run. The data file library for that run is below.

I no longer have a version of Studio available to confirm on Foundation.
Hope this helps,
Sigrid
------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------