My question is, how would one go about setting up a task to run nightly?
The problem at hand is, company A stores data on company B's server. Then nightly, company B creates an XML feed for them to take the updates and put them in there own database server (that I am going to set up). The website never sends updates back, the only updates from company A are from inside there office system.
So, what I have to do is take this XML feed and put it in my own server. It could be a fairly large number of records (500 maybe) - So I'm not sure how fast it could realistically be parsed through and then added to the database.
How do I go about this without checking each time a user visits the website? It needs to be automatic too, rather than somebody going to the specific page each night and clicking 'go'.