title: Sending emails automatically using SQL Server job
body: <p>I'm developing a .NET desktop application with SQL Server as the database backend. One of the requirements of the application is that if a record status, for example, remains inactive for 30 days, there will be a reminder email sent to the user associated to that record.</p>
  
  <p>This could be done pretty easily within the application, as long as it is started and running. However, assume that for a certain period of time, nobody starts up the application, the reminder email won't be sent, because nothing / nodody triggers the action.</p>
  
  <p>How about creating a job in SQL Server which can monitors the records and sends emails as needed? Has anyone ever done that?</p>
  
  <p>Thanks a lot!</p>