I am looking for some high-level suggestions on how to build the following:
During the process of about two weeks, a few jobs will need to run a few times a day, at very precisely given times. These jobs include:
- Pulling/pushing files from/to FTP servers.
- Running an SSIS (that's Microsoft's ETL solution) package.
- Running a C# program that's compiled as
.exe.
All of this happens on Windows Servers.
As a programmer, my first thought was to write a tool in C# that can run for a couple of weeks, and just executes these other tasks at the given points in time. This sounds like overkill and difficult to maintain, though.
What would your solution be?
