Running Stored Procedure every 5 minutes

Luann_Dias

Hello,

How would I go about having a form sit idle and run a stored procedure every 5 minutes using the Timer event?

Thanks,

DonBakke

You start by setting the TIMER property for your form. This configures the form's TIMER event frequency and whether it reoccurs or just fires only once. You could simply configure it to run every 5 minutes and then you just add your call to your stored procedure in the TIMER event itself. However, I prefer to only call my TIMER event once and then when the TIMER event is done, I set the TIMER property again to execute in another 5 minutes. The reason I like this is because if you need to debug your TIMER event, you won't get OI stacking several TIMER events.

Luann_Dias

Worked first try, thank you Don!