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 2000 Forums
 SQL Server Development (2000)
 Tsql return codes to SQL agent Jobs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-05-06 : 14:23:17
Ron writes "I have a multi step sql agent job which runs different stored procedures in each step. How do I pass a return code to sql agent to cancel the next job step when I hit an abnormal condition in the stored procedure. I tried the tsql return verb but the next step still ran.

Thanks for any help.
RG"
   

- Advertisement -