how to update database after a period of time.... using timer is it possible??

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • santhi10
    New Member
    • Oct 2013
    • 1

    how to update database after a period of time.... using timer is it possible??

    i am doing a project ...in the data base i have to update an attribute value as"activated" ( user_id) after 3hrs......any solution....??a m using sqlsever 2008 as backend
  • Frinavale
    Recognized Expert Expert
    • Oct 2006
    • 9749

    #2
    ASP.NET is only run when it is requested.
    I'm sorry, I do not think it is possible to do this with ASP.NET alone. You may need to write a Windows Service or some other application that periodically checks which user's are new, and set them to "activated" if they are older than 3 hours.

    -Frinny

    Comment

    Working...