title: Periodic event implementation
body: <p>I have an ASP.NET MVC 2 web-site. All the buisnes is in the databse stored procedures (MS SQL SERVER 2008).<br>
  The task:<br>
  Some user creates record, using web-site. Appropriate row inserts into the table. This row has foreign key to another table, its value sets in the procedure. Then I want application to reassign record (change foreign key field) to another, if it was not handled during 1 minute.<br>
  For example:<br>
  1. User creates record <code>A(id = 1, adminId = 1)</code>.<br>
  2. Only administrator with id=1 see this record and he should handle it during 1 minute.<br>
  3. If admin 1 not handles record during 1 minute, it should be reassigned to another administrator. For example <code>A</code> updates to <code>(adminId = 3)</code>.<br>
  Which way would be better to do this? Parallel thread? Another application in background? Or...</p>