Program a transformation that takes place every day without me having to activate it or do anything.
I'm creating different files through a database query but I want everything to be done automatically.
Greetings and forgiveness for my English.
Well, to do that, you create your transformations and jobs to generate the files, and then depending on where you are running them, you schedule the automatic execution:
Whatever you use to schedule, you have to implement some system to monitorize that the execution has gone without problems and to catch errors if there's some problem.
Retrieving data ...