-
This is going to sound incredibly weird.
On the first day of each month, I need to update a table with values that I can only get by running a chunk of code which is based on tables from the same database. This code computates certain values and updates a the database with the new values. I would do it each time a recordset is needed however it takes a lot of time to process.
Here is my delimma. I don't know how to set up the scheduling of it. Could I set up a stored proceedure in my SQL7.0 db that runs when its 1am on the first of the month and executes a shell command to run the vb exe that I create to bring in the data do the computation and then the update? Or is it possible to put this in an activeX dll (including the monthly scheduling)?
Its unfortunate that the data can be manipulated in SQL like I need for it to be!
HELP HELP HELP
-
..could be wrong
this pops up in my head as I read this..
create a very simple program with a timer that checks every 3 minutes the system date and time and checks it against, say, an array of valid 1st of the month dates for the whole year...
This program would be kicked off upon starting the computer
and would remain in the background
If it finds a match, shell the appropriate program you want to execute to accomplish your task, and upon return, update
your array by removing the date month for which it is already run...
I am saying an array, but it could be something else like an ini file etc...
to check...
have the program automatically send an e-mail to concerned parties that it was executed for that date...
