Avoid SQL Job failure when warnings are encountered
Posted on 2008-10-08
I have a question about setting "allow warning" (I don't know how to call it) within the SQL jobs, and wondered if anyone can help. I am monitioring an SQL 2000 Server, and within it, it contains a few SQL Jobs. The jobs have been running fine all these times, but then one of them started to failed the last couple days.
The step that failed is in the middle of the job. I tried to run that particular step in Query Analyzer, and it completed with an warning. but if the job is auto-run in SQL Enterprise Manager, then it would fail. I think I have heard (or read) somewhere that we can skip the non-so-critical messages, so the job would continue on without failing, but I couldn't recall what that is or where I can find that option. Does anyone know what is that call, or where should I look for that information?
Thanks in advance!