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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sql job steps warnings.

Author  Topic 

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-04-22 : 11:47:58
i have setup a sql job with 4 steps
1-checkdb
2-indexdefrag
3-sp_updatestats
4-email notification.

if 1,2 success go next step
if 1,2,3 fails go step 4
if 3, 4 success quit with success
if 4 fails quit with failure

i 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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -