Databases
StackOverflow2013
Postsdbo
POTo raise an event every hour has passed in system clock
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POTo raise an event every hour has passed in system clock
    primarykey
    data
    text
    <p>I want to raise an event every time each hour has passed in system clock. For example, I run my program at 7:45 am then the event should be raised at 8:00 am, not at 8:45 am. After the event raised at 8:00 am, then this event should be raised at every hour 9:00 am, 10:00 am, 11:00 am, etc...</p> <p>Can anyone help me to show some code... I use C#.net... Thanks in advance...</p> <p><strong>UPDATE:</strong></p> <p>Now I get the simple solution for my question. Therefore I would like to share this solution. lboshuizen's answer is already correct. My answer is same logic with lboshuizen's answer but more detail and exact.</p> <p>Firstly it needs to use Timer. Timer basically works based on milliseconds which sometimes needs additional calculation. Therefore, I would like to implement milliseconds to minute formatting function as first. </p> <pre><code>int CalculateMillisecondUntilNextHour() { int REMAIN_MINUTE = 60 - DateTime.Now.Minute; DateTime now = DateTime.Now; DateTime nexthour = now.AddMinutes((minute)).AddSeconds(now.Second * -1).AddMilliseconds(now.Millisecond * -1); TimeSpan interval = nexthour - now; return (int)interval.TotalMilliseconds; } void CheckEachHourPassed() { System.Windows.Forms.Timer t = new System.Windows.Forms.Timer(); t.Interval = CalculateMillisecondUntilNextHour(); t.Tick += new EventHandler(t_Tick); t.Enabled = true; } void t_Tick(object sender, EventArgs e) { MessageBox.Show("Raise Your Event"); t.Interval = CalculateTimerInterval(REMAIN_MINUTE); } </code></pre> <p>At here, the main working function is CheckEachHourPassed(). Call this function where you want to start your event scheduler. </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USNay Lin Aung
    1. USNay Lin Aung
    plurals
    1. PL
      singulars
      1. LTLinked
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POTo raise an event every hour has passed in system clock
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POTo raise an event every hour has passed in system clock
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POTo raise an event every hour has passed in system clock
      1. This table or related slice is empty.
      1. VTUpMod
    1. COgoogle will tell you for sure
      singulars
      1. POTo raise an event every hour has passed in system clock
      1. USPavenhimself
    2. CO@daveL, Nothing, that's obvious
      singulars
      1. POTo raise an event every hour has passed in system clock
      1. USlboshuizen
    3. COwhat have you tried? Have you seen [this](http://stackoverflow.com/questions/4122509/is-there-an-event-that-fires-at-a-specific-time)?
      singulars
      1. POTo raise an event every hour has passed in system clock
      1. USMilkyWayJoe
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload