title: Create a scheduled job using MSSQL Agent
body: <p>It's my first time working with SQL Agent and i don't have much experience with it!<br>
  I need to create a scheduled job that checks few columns of a table everyday and updates one of them based on today's date!</p>
  
  <p><strong>Project table's columns:</strong></p>
  
  <pre><code>CREATE TABLE [dbo].[Project](
  [projectID] [int] IDENTITY(1,1) NOT NULL,
  [prID] [nvarchar](50) NULL,
  [projectName] [nvarchar](20) NOT NULL,
  [startDate] [datetime] NOT NULL,
  [dueDate] [datetime] NOT NULL,
  [progress] [int] NULL,
  [status] [bit] NULL,
  </code></pre>
  
  <p>I need to update the <code>status</code> column everyday based on the progress that the project has this now using the <code>startDate</code> column and <code>today's date</code>. basically something like:</p>
  
  <p>ExpectedProgress = <code>(todayDate-startDate)*(100/(dueDate-StartDate))</code>
  Now by comparing the <code>progress</code> column and the <code>ExpectedProgress</code> i can set the value of <code>status</code> column true (on time) or false (late)</p>
  
  <p>Thanks in Advance! </p>