July 31, 2007 at 9:24 pm
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
August 1, 2007 at 10:46 am
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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply