title: Creating a cron job in SQL server that executes a procedure every day
body: <p>I am working on SQL server and  have a procedure that takes data from one table and put into other table. I want to execute  this procedure every midnight. I have searched on this
  I didn't find a proper  way to achieve this.</p>
  <p>My procedure is &quot;archive_table_sp&quot; I want to run this every day at 12 midnight</p>