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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 SQL Job

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2007-06-19 : 18:59:19
Is there an option to invoke "fail job" event in SQL2K5?

I have a job with multiple steps. If a perticular condition is met I don't want the process to continue. Any ideas?

------------------------
I think, therefore I am - Rene Descartes

cvraghu
Posting Yak Master

187 Posts

Posted - 2007-06-19 : 19:40:19
I'm not sure about this, but you can give a try using Raiseerror.
Go to Top of Page
   

- Advertisement -