Getting the error of the Backup Job in SQL Agent to email when it fails ??

• kasaranenikiran-725528

  SSC Eights!

  Points: 818

  More actions

  February 28, 2011 at 7:32 am

  #235755

  Hi,

  I have some Backup Jobs set up in SQL Agent Job through SQL Script and some with Litespeed script . I see some of the back up jobs Fails often and I had to manually check the history of the Job to find the Error Log.

  How can I automate to send the error log directly to email (or) DBA group when a Agent Job fails ??

  Please suggest

  Regards

  Kay

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  February 28, 2011 at 9:12 am

  #1292396

  Duplicate post. All responses at http://www.sqlservercentral.com/Forums/Topic1070515-146-1.aspx

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga