Update record at the end of the day
Posted on 2013-02-04
OK, I figured out my own question, so now, I have this new question, of which I have seen around a few times, here on EE, however, none of the solutions that I can recall, were really that good, unless I missed the good ones.
I am going to write a script that will calculate my total views across all rows for each day.
Now, HOW (This is the question:) Will I execute the script?
This is going to be Classic ASP.
I was thinking about having a webpage executed from my computer, from a "Scheduled Task", that will load the page, that will then execute the script, and have this done at midnight my time, or the servers time, of which I think is my time as well.
However, what if my internet is down at that time, what will happen then?
Is there a way to have something server-side to execute the script?
Keeping in mind, that I do not have access to the servers, as they are hosted, not personal.
Any idea's on this one?