title: Create jobs in SQL Server Express edition?
body: <p>I want to schedule some jobs in sql server express edition. After digging a bit i got few post like:</p>
  
  <p><a href="https://stackoverflow.com/questions/1675206/how-to-run-a-stored-procedure-every-day-in-sql-server-express-edition">How to run a stored procedure every day in SQL Server Express Edition?</a></p>
  
  <p><a href="https://stackoverflow.com/questions/7201061/how-to-create-jobs-in-sql-server-express-edition">How to create jobs in SQL Server Express edition</a></p>
  
  <p><a href="https://stackoverflow.com/questions/1675206/how-to-run-a-stored-procedure-every-day-in-sql-server-express-edition">How to run a stored procedure every day in SQL Server Express Edition?</a></p>
  
  <p>and i understand that Sql Agent is require to schedule a job in sql server but since SQL Server express does not come with SQL Agent so i have to go with some other alternative.</p>
  
  <p>And i got <a href="https://stackoverflow.com/questions/1675206/how-to-run-a-stored-procedure-every-day-in-sql-server-express-edition">this</a>, which suggest good and easy alternative. Here in @Thomas Bratt's answer he used <em>infinite loop</em> and <em><a href="http://technet.microsoft.com/en-us/library/ms187331.aspx" rel="nofollow noreferrer">waitfor</a> (Transact-SQL)</em> </p>
  
  <p><em>Code from @Thomas Bratt's answer</em></p>
  
  <p>I want to know the performance impact (if any) of this code.   </p>
  
  <pre><code>...
  while 1 = 1
  begin
      waitfor time @timeToRun
      begin
          execute [MyDatabaseName].[dbo].[MyDatabaseStoredProcedure];
      end
  end 
  ...
  </code></pre>
  
  <p>and in the <a href="https://stackoverflow.com/questions/1675206/how-to-run-a-stored-procedure-every-day-in-sql-server-express-edition">same post</a> @Raj More suggest another alternative i.e Windows Scheduler, so which one is better to use <em>Windows Scheduler</em> or <em><a href="http://technet.microsoft.com/en-us/library/ms187331.aspx" rel="nofollow noreferrer">waitfor</a> (Transact-SQL) with infinite loop</em> ??</p>