Display update status of Windows task Scheduler

[jadams0173]

I have a split DB where the backend tables update every 15 minutes. This happens by running an EXE that I wrote in VB and is activated off the windows task scheduler.

Question is, I would like to be able to show an update status on my form in the front end of my DB. My DB has only one form. This would show the user if the tables were updating, when the last time they updated, and when is the next scheduled time to update.

Could this be accomplished by using the values from the task scheduler its self or would I be better off to store them in table? I've thought thru a few ways that I may be able to make this work but just thought I would present it for ideas.

 

[abaldwin]

I think you would be better off modifying the VB application to put up a form on the screen with a progress bar or some other visual notification instead of trying to interact with an access application that may or may not be open.


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[JerryKlmns]

jadams0173,

Since you play with VB and update the BE mdb how about add a table in your FE to keep the info you like, dispaly that on your form and modify your VB app to updata those values?

Andy's approach suggests to modify your VB app to stay up and fire the update actions upon a timer event and visualize the process.

 

[jadams0173]

Jerry and Andy,

Thanks for the suggestions. That's kinda the way I was thinking of going was adding an update table. I would put a timer on my FE form and have it check the table for the status and the last and next update and display that info on the form. Then make this the first bit of code in my update application to modify these values.


I'm going to try this approach and I'll post back and let ya'll know how it came out.

 

[Coder12345]

I was wondering if you could share the code that you used to schedule the job. I have a sql server database with acess front end and would like to schedule a job. Any help is appreciated

 

[jadams0173]

I did take the approach suggested and all seem's to be working well. Thanks again for the input. I put an update table in the BE and placed a timer on my form that looks at the table every 15 seconds. I change a 0 to a 1 to indicate and update and PHV helped me out with calculating the next update time.

Coder12345,

The task scheduler is built into windows and needs no code.