Welcome to the SRP Forum! Please refer to the SRP Forum FAQ post if you have any questions regarding how the forum works.

Running Stored Procedure every 5 minutes

Hello,

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

Thanks,

Comments

  • 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.
  • Worked first try, thank you Don!
Sign In or Register to comment.