Job Failures and Event Viewer Error
-
System is SQL2000 SP3. When a job fails we have the job write to the Windows Application event log. Currently, a particular job failed and it wrote a "warning" to the application event log. The reason I want to do this is because we use a web based alerting system called Site Scope; we have an alert set up that monitors the application event log for errors. So, when the job failed we didn't get a notification of the failure. I know I could set up a Site Scope alert for "warnings" but I don't want to take that step at this time. How do I get SQL Server agent to write "errors" to the application event log. Thanks for the help.
-
http://support.microsoft.com/default.aspx?scid=kb;en-us;169960
this may help u how to write the error to the application event log.
from
Killer
-
Am I missing something, this article is titled:
INF: Analyzing and Avoiding Deadlocks in SQL Server
How does this article help with my scenario?
I'm confused, which is typically not that hard to do. =
Mark
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply