title: SQL Server: Database Maintenance Plan
body: <p>I have a small database for a school project and I need to create a Database Maintenance Plan with the following requirements:</p>
  
  <ul>
  <li>it has to manually (through scripting and not user interface)</li>
  <li>it must reorganize data and indexes</li>
  <li>it must validate database integrity</li>
  <li>it must be run automatically everyday at 19:00</li>
  </ul>
  
  <p>well, I have absolutely no idea on how to do this</p>
  
  <p>Can someone help me out, please?</p>
  
  <p>I found some commands to create backups and reorganize indexes but I can't find a way to run them periodically.</p>
  
  <p>Thanks
  Chiapa</p>