Posted by Mike on 09/20/05 17:12

Thanks GP, but when I uncheck the "Write to the Windows Application
Event Log"
option the job still writes to the Application Event Log. I noticed
some strange behavior when unchecking this option. When it is checked
the drop down that's associated with it is showing "When the job fails"
so before unchecking it I changed the drop down to "When the job
succeeds" and then unchecked the box. After applying the changes and
running the job, the Application Event Log still gets written to, and
when I go back to the job I just changed, I see the disabled drop down
showing "When the job fails" again. I want to see the messages getting
written if the job fails, but only suppress the informational messages
upon success, but either way this method fails to suppress the
successful informational messages. FYI, I have never seen the
Transaction Log Backup job fail.

• Next in forum: Re: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log
• Prev in forum: Re: Insert based on a select query
• Thread view: Re: How Do I Prevent SQL 2000 From Posting This Message To The Event Viewer - Application Log

[Reply to this message]