title: SQL Server 2008 Agent jobs. Two procedures and a view
body: <p>I'm using two stored procedures a view to create report.</p>
  
  <p>Every 3 months, I have to update these two stored procedures and view automatically.</p>
  
  <p>First, I should update stored procedure 1</p>
  
  <p>Then, I need to update view (it takes data from stored procedure 1)</p>
  
  <p>Finally, I need to update stored procedure 2 (it takes data form stored procedure 1 and from the view)</p>
  
  <p>To do this, I would like to use SQL Server Agent jobs. Is it possible to run one SQL Server Agent job and updated these two store procedure and view in that sequence? or should I create SQL Server Agent job with command to update stored procedure 1 then I need to create another job with command to update view and then create another job with command to stored procedure 2.</p>
  
  <p>Thank you for any suggestions.</p>