notify job step failures...

• Cory E.

  SSCertifiable

  Points: 7076

  More actions

  July 31, 2007 at 9:24 pm

  #118060

  Good day,

  Today, I was informed that a certain job we have has been failing, and failed to notify anyone.  Upon further inspection, here is what I found. 

  This job has four (4) steps.  Step 1 & 2, upon failure or success, goes to next step, step 3 fails on failure, continues on success, and step 4 terminates upon completion.

  Step 1 failed, moved to steps 2, 3 and 4 successfully.  The end result is, as one would expect, shows successful.  The person in charge of that job wants to be notifyied when any part fails.  What options may I have?

  I am sure I could break the job into individual jobs, but I not wanting to do that.  I thought I saw that 2005 could give step level notifications...but I cannot see that now that I need it.

  TIA

  Cory

  -- Cory

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  August 1, 2007 at 10:46 am

  #723959

  SQL 2005 gives the option to log step results to a table.  You could check that for each step, then query the table in the last step of the job or in a separate job and email the job administrator.  See "How to: Set Job Step Success or Failure Flow" in BOL.

  Greg

  Greg