title: how I can resend all failed emails (msdb.dbo.sp_send_dbmail)
body: <p>I am sending emails using msdb.dbo.sp_send_dbmail.
  Sometimes the emails do not send. I have got the list of emails which have failed.</p>
  
  <pre><code>SELECT TOP 10 * from msdb.dbo.sysmail_event_log 
  
  
  log_id  event_type  log_date    process_id  mailitem_id account_id  last_mod_date   last_mod_user
  9022    error   50:15.9 5608    20428   NULL    50:15.9 sa
  9023    error   51:23.3 5608    20428   NULL    51:23.3 sa
  </code></pre>
  
  <p>Now, I want to resend all failed emails again which are available in the  sysmail_event_log table.</p>
  
  <p>How can I resend all failed emails?</p>