| Greg M. Lucas 2002-10-05, 9:12 pm |
| Hey EB,
Looks like you're experiencing the same issue as me - let me know if you
find anything that doesn't get posted.
Many Thanks,
Greg
gmlucas@bigfoot.com
"EB" <clarifyadmin@statpro.co.uk> wrote in message
news:1c4e01c17835$4cc65270$9ee
62ecf@tkmsftngxa05...
> I have a 4-step job. The SQL used in this job works OK
> if done through Query Analyzer because it doesn't stop the
> transaction if there is an error.
> However, when I put the same SQL in a job, the job stops
> when it encounters an error. The errors don't actually
> matter. Even if I set the job to continue to the next step
> on failure it doesn't complete the step it's on, it counts
> the error as a fail.
> How can I make the job ignore the errors and carry on to
> the end of the
> step?
>
> Thanks in advance
>
>
|