I need to integrate a custom force.com app with data feeds that should be scheduled to run nightly and upsert data into different custom objects. I need to create a nightly schedule with dependency management. For example, "Do not load file b until file a has completed, etc."
I also need some alerting capability that notifies individuals when the scheduled job has completed and with job details (#success/#error). There would also need to be error logging by record/row similar to the logs that the Apex Data Loader and Jitterbit provide.
The most important requirement is that the credentials for the "running user" should not be stored in a third-party solution like Jitterbit's server.
Is there any Salesforce.com solution that will meet these requirements? Or, is the only solution to build an integraiton that calls the Salesforce.com SOAP/REST APIs?