Notification

Question

Notification

RGP

SSCarpal Tunnel

Points: 4381
More actions
August 4, 2008 at 12:50 am

#210799

What is the difference between alerts and notification in sql server 2000? can we send out an email for only one particular job step, if it fails??

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Loner SSC-Insane Points: 21279 More actions · Answer 1

In every job step, you can choose which step to go when it fails and which step to do when it succeeds. When one step fails, I will choose the tab to quit the job and report failure.

For example,

Step 1 - Succeed - go to step 2, Fail - Quit the job reporting failure

Step 2 - Succeed - go to step 3, Fail - Quit the job reporting failure

Step 3 - Succeed - Quit the job reporting failure successful, - Quit the job reporting failure

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 2

Loner (8/4/2008)
In every job step, you can choose which step to go when it fails and which step to do when it succeeds. When one step fails, I will choose the tab to quit the job and report failure.
For example,
Step 1 - Succeed - go to step 2, Fail - Quit the job reporting failure
Step 2 - Succeed - go to step 3, Fail - Quit the job reporting failure
Step 3 - Succeed - Quit the job reporting failure successful, - Quit the job reporting failure

thanks , however I would like to have the job step to proceed to the next step, even if its failed, and then send an email reporting the step failed(at that step where the job failed)

GSquared SSC Guru Points: 260824 More actions · Answer 3

You can do that by adding an e-mail notification step.

On success of step 1, have it to go step 2. On failure of step 1, have it go to an e-mail notification, and then have the e-mail notification step go to step 2.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

RGP SSCarpal Tunnel Points: 4381 More actions · Answer 4

GSquared (8/4/2008)
You can do that by adding an e-mail notification step.
On success of step 1, have it to go step 2. On failure of step 1, have it go to an e-mail notification, and then have the e-mail notification step go to step 2.

thanks