A question for the GURU's Stored Proceedure!

[VBDever]

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)?


HELP HELP HELP

[Lethal]

Well, i am not sure how to go about doing a stored procedure, but why not either write a program to do the update or use your current one, and add it to your scheduled tasks, then it will run automatically when you tell it to.

[VBDever]

I considered that. The project that I am working on is very large. I don't want to have to depend on a scheduler to execute this. I would prefer to keep all of my eggs in one basket if at all possible. Any ideas?

[Bigley]

In enterprise manager in SQL 7.0 choose the appropriate server then choose management then SQL Server agent then jobs and you can then schedule anything to run when you want. That is the best way for setting up end of day or start of day jobs.

However I would recommend using stored procedures to carry out all computations as opposed to calling a VBDLL.
Good luck