Mailing when the Sql Job Processor fails

• srisagar_p

  SSChasing Mays

  Points: 623

  More actions

  January 13, 2009 at 8:44 am

  #196120

  Dear Members,

  I need an alert type of solution when the Job Processor fails.

  Is it possible to send a mail automatically when an sql job processor fails with out using

  Sql mail concept which is available in sql server.

  Please help me regarding this issue which will helps mme a lot.

  Thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 13, 2009 at 10:19 am

  #926057

  Why would you not want to use the built-in mailing capabilities of SQL Server? You have not posted this in an appropriate forum so I don't know what version of SQL Server you are using either.

  If you don't want to use SQL Mail you would have to write a custom process that monitors msdb.dbo.sysjobhistory.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  January 13, 2009 at 10:33 am

  #926072

  Do you mean when any JOB fails or when the Job Processor(SQL Agent) fails? These are completely different things.

  And why don't you want to use the built-in mail facilities?

  And what version of SQL Server are you using?

  And why are you posting this here?...

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]