title: How to handle SQL Agent job error?
body: <p>I am writing a SQL Agent Job to remove rows from Table 1 and Table 2 once a day. The step of the SQL Agent job is:</p>
  
  <ol>
  <li>Delete some specific records from Table 1</li>
  <li>Delete some specific records from Table 2.</li>
  </ol>
  
  <p>My question is:</p>
  
  <ol>
  <li>How to record the error during SQL Agent? Any logs/events we could use? (so that we could see in what days the SQL Agent Job failed, and why it failed.)</li>
  <li>I want the SQL Job to continue to execute (delete) specific records from Table2, even if for any reason delete from Table1 fails, any best practices how to implement this?</li>
  </ol>