Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tejokrishna
Starting Member
6 Posts |
 Posted - 2014-02-11 : 17:58:48
|
| Hi, Pls tell me, How to create alert after job failed for two times (I dont want to create alert for first time job failure).Y.Tejo Krishna |
|
|
allenhadler
Starting Member
3 Posts |
Posted - 2014-02-14 : 13:07:43
|
| Easy way.1. Setup a second step that matches the first.2. On failure of first step goto seconds step.3. on failure of second step report failure.To get to step order right click on the step goto properties and select advanced on the left side. you should see options for On Success and on Failure.Allen Hadler |
 |
|
|
|
|
|
sql server jobs related