sp_add_alert to capture backup failure in form of alerts

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  May 19, 2015 at 5:11 pm

  #300793

  Hello Experts,

  I want to throw alerts to the inbox if there's any backup failure occurs part of the job step.

  Can you suggest what will be the right category of message I should use?

  For e.g, for tempdb file full, I use mesg id as : 9002, which signifies trn log is full.

  EXEC msdb.dbo.sp_add_alert @name=N'Full tempdb',

  @message_id=9002,

  @severity=0,

  @enabled=1,

  @delay_between_responses=910,

  @include_event_description_in=3,

  @database_name=N'tempdb',

  @category_name=N'[Uncategorized]',

  @job_id=N'00000000-0000-0000-0000-000000000000'

  Thanks.