title: how to send an email alert if backup fails via SQL Job
body: <p>I'm going to run via a <code>SQL Job</code> a backup which will back up 4 databases.  What I want to do is to be able to send an email via my <code>Database Mail profile</code> if any of the backup's fail.</p>
  
  <p>Now I know there is a very obvious way of doing this on the job itself but my boss doesn't want it done like that. </p>
  
  <p>What we want is within the <code>T-SQL</code> code for the job is to be able to detect the backup failing or the job itself failing and then send the email.</p>
  
  <p>I hope I've explained the issue.</p>
  
  <p>Thanks to everyone in advance who may have some ideas for me.</p>
  
  <p>Nick  </p>