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 |
|
funketekun
Constraint Violating Yak Guru
491 Posts |
 Posted - 2008-04-22 : 11:47:58
|
| i have setup a sql job with 4 steps1-checkdb2-indexdefrag3-sp_updatestats4-email notification.if 1,2 success go next stepif 1,2,3 fails go step 4if 3, 4 success quit with successif 4 fails quit with failurei created a script and pasted it in production server and i get this msg:Warning: Non-existent step referenced by @on_fail_step_id.Warning: Non-existent step referenced by @on_fail_step_id.Warning: Non-existent step referenced by @on_fail_step_id. how can i fix it? I think the error is due to step 4 not executing before calling it from stepe 1,2,3 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-22 : 12:57:58
|
| You can't fix it. They are just warnings and are incorrect anyway. I've got a similar job that gives the same warnings. It should be classified as a bug.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
sql job steps warnings.