Loading
I want to insert a value daily every after 3 minute in sql server 2012
+2

  • Sachin RathorePosted Sep 1, 2020, 5:05 AM

    Thanks sir your code is working. If I close my session website after that is it also workig automatically running.
    +1

  • Sachin RathorePosted Sep 1, 2020, 3:53 AM

    Sir please give me an explample of this type of question and
    how can i done with triger 
    +1
  • Laxmidhar Sahoo

    Laxmidhar SahooPosted Sep 1, 2020, 3:45 AM

    hi
     
    In timer tick event with interval 3 minutes call insert statement . Increment a counter  increased by 1.
     
    when the counter value will be 480 then change the id . Because a hour has 20 innervals for 3 minutes 
     
    interval time ,For 24 hours it will be 20x24 
     
    Thanks  and regards
    +2