需要一个定时器在特定时间和每 5 分钟触发一次直到作业完成 [英] Need A Timer To Fire At Specific Time And Every 5 Minutes Until Job Complete

问题描述

我需要帮助为我的应用程序设置特定类型的计时器.我的场景是这样的:

I need help setting up a specific type of timer for my application. My scenario is this:

我想在一天中的特定时间(比如凌晨 4:00)运行计时器.然后，该计时器执行许多不同的事件，每个事件都会触发并从数据库中获取数据并对其进行处理(使用后台工作程序).所有不同的事件需要不同的时间来完成(可能是 30 秒，可能是 5 分钟).我想每 5 分钟连续输入一次计时器事件，然后检查所有事件是否已完成.如果是这样，请停止计时器并在第二天早上 4:00 重新启动它，依此类推.

I want to run a timer at a specific time of day (say 4:00AM). That timer then executes a number of different events that each go off and grab data from a database and process it (using background workers). All the different events take different times to finish (could be 30 seconds, could be 5 minutes). I want to continuously enter the timer event every 5 minutes thereafter checking if all events have finished. If so, stop the timer and restart it again at 4:00AM the next morning and so on.

所以这个过程看起来像这样:

So the process would look like this:

04:00AM - 启动计时器并启动后台工作人员
04:05AM - 再次检查进程是否已完成(如果是，停止计时器)
04:10AM - 再次检查以查看进程是否已完成(如果是，停止计时器)
等等……

04:00AM - Start Timer and initiate background workers
04:05AM - Check again to see if processes have completed (if so, stop timer)
04:10AM - Check again to see if processes have completed (if so, stop timer)
And so on....

我已经有了处理我的数据库信息的后台工作代码.所以我只需要帮助设置计时器.

I already have my background worker code that processes my database information. So I just need help setting up the timer.

到目前为止，我的 Tick 事件中有以下内容:

So far I have the following in my Tick event:

Private Sub tmr_Maintenance_Tick(sender As Object, e As EventArgs) Handles tmr_Maintenance.Tick
    Dim CurrentTime As Date
    Dim CurrHour As Integer

        CurrentTime = DateTime.Now
        CurrHour = CurrentTime.Hour

        'Automatic Sales Import
        With My.Settings
            If CurrHour = 4 Then

                If Not .Maintenance_Ran Then
                    CreateLog("Maintenance Started")

                    If Not .Yesterdays_Sales_Imported Then
                        CreateLog("Importing Yesterday's Sales From Portal")
                        If Not YesterdaysSales_Worker.IsBusy Then YesterdaysSales_Worker.RunWorkerAsync()
                    End If

                    If Not .WTD_Sales_Imported Then
                        CreateLog("Importing Week To Date Sales From Portal")
                        If Not WeekToDateSales_Worker.IsBusy Then WeekToDateSales_Worker.RunWorkerAsync()
                    End If

                    If Not .LW_Sales_Imported Then
                        CreateLog("Importing Last Week Sales From Portal")
                        If Not LastWeekSales_Worker.IsBusy Then LastWeekSales_Worker.RunWorkerAsync()
                    End If

                    If .Yesterdays_Sales_Imported = True And .WTD_Sales_Imported = True And .LW_Sales_Imported = True Then
                        .Maintenance_Ran = True
                    End If
                End If
            Else
                .Maintenance_Ran = False
            End If
        End With

    My.Settings.Save()
End Sub

感谢任何帮助.

推荐答案

这里有一个基本的框架，你可以从:

Here's a basic framework you can start from:

Public Class Form1

    Private Enum MaintenanceState
        WaitingToStart
        Started
    End Enum

    Private Target As DateTime
    Private state As MaintenanceState = MaintenanceState.WaitingToStart
    Private MaintenanceTime As New TimeSpan(4, 0, 0) ' 4:00 am
    Private WaitingInterval As New TimeSpan(0, 5, 0) ' Five minutes

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Target = GetNextMaintenanceTarget(MaintenanceTime)
        tmr_Maintenance.Interval = 1000
        tmr_Maintenance.Start()
    End Sub

    Private Sub tmr_Maintenance_Tick(sender As Object, e As EventArgs) Handles tmr_Maintenance.Tick
        ' optionally display time remaining until next target
        Dim ts As TimeSpan = Target.Subtract(DateTime.Now)
        Label1.Text = ts.ToString("hh\:mm\:ss")

        ' see if we've hit the target
        If DateTime.Now >= Target Then
            tmr_Maintenance.Stop()

            Select Case state
                Case MaintenanceState.WaitingToStart

                    ' ... start all the jobs ...

                    state = MaintenanceState.Started
                    Target = DateTime.Now.Add(WaitingInterval)

                Case MaintenanceState.Started

                    ' ... check to see if the jobs are all done ...

                    If Not AllJobsCompleted Then
                        Target = DateTime.Now.Add(WaitingInterval)
                    Else
                        state = MaintenanceState.WaitingToStart
                        Target = GetNextMaintenanceTarget(MaintenanceTime)
                    End If

            End Select

            tmr_Maintenance.Start()
        End If
    End Sub

    Private Function GetNextMaintenanceTarget(ByVal time As TimeSpan) As DateTime
        Dim dt As DateTime = DateTime.Today.Add(time)
        If DateTime.Now > dt Then
            dt = dt.AddDays(1) ' already past target time for today, next start is tomorrow
        End If
        Return dt
    End Function

End Class

这篇关于需要一个定时器在特定时间和每 5 分钟触发一次直到作业完成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！