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 |
|
rongrzywacz
Yak Posting Veteran
57 Posts |
 Posted - 2001-05-01 : 15:07:00
|
| Running SS 7.0 sp3. I have a sql agent job, with multiple steps which call stored procedures. How do I, from within the stored procedure, pass a return code to sql agent, to force the step into a failed status. I don't want any steps afterward to run. I've tried using the return code, but Sql agent seems to thinkt that the job succeded.Thanks for the help,RGRon Grzywacz |
|
|
|
|
|
sql server agent job return codes