title: How to schedule a database task?
body: <p>Background: I created an application that measures a weight from a scale and saves the information in MS SQL server database.</p>
  
  <p>In the database, I want to save a record for the actual weight for every day as historical, and I don’t know what I have to use to accomplish this task.</p>
  
  <p>Can a trigger in SQL Server do it ??</p>