I am running a stored procedure as a job step and in the stored procedure I use return to pass one of several possible values when there is an error in processing (not an system error) so that the job step will fail. However, even when I return a non-zero value using return the job step completes as successful. What should I be doing so that the job step picks up the non-zero value and then indicates the step failed?
Try using a RAISERROR with a severity greater than 10.
-Sue
|||Thank you very much Sue
No comments:
Post a Comment