August 22, 2003 at 11:17 am
What I have now is a stored procedure that checks the status of something and if there is nothing there it raises an error and returns a -1.
Is it the raised error that causes the step to fail?
Otherwise it returns one of three other values. The way it is set up now if the job fails it shows up in my log of failed jobs and it runs every five minutes. Very annoying!
What I want to do is based on the return value of the SP go to another step that will just record a status but allow the job to end successfully.
I could get rid of the raised error but how can I pass data from one step to another? temp table?
"I met Larry Niven at ConClave 27...AND I fixed his computer. How cool is that?"
(Memoirs of a geek)
August 25, 2003 at 3:40 am
I think so, thought I have not tested. In ActiveX steps any error will fail the step, as will returning any non zero value from a OS task.
Yes, a table is the way to go if you need to pass a value between steps.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply