How can I make all services and jobs and etc verbosely log to the Application Log on the server? Replication stuff goes to a table, jobs go to tables, etc. I would like to centrally capture them all so my monitoring tool can just go to a single place. Thanks.
If the tools are not writing to the app eventlog and can't be configured to do so, you would have to trap the errors yourself, and write them to the app eventlog yourself. Linchi "Co Co Net" wrote: > How can I make all services and jobs and etc verbosely log to the > Application Log on the server? Replication stuff goes to a table, jobs > go to tables, etc. I would like to centrally capture them all so my > monitoring tool can just go to a single place. > > Thanks. >
Some things like Replication are logged to a table. I would like the same thing to be written to the Event Log. Isn't there a way to make SQL Server operations go to the Application Event Log? On Mon, 21 Jul 2008 11:11:01 -0700, Linchi Shea wrote: >If the tools are not writing to the app eventlog and can't be configured to >do so, you would have to trap the errors yourself, and write them to the app >eventlog yourself. > >Linchi > >"Co Co Net" wrote: > >> How can I make all services and jobs and etc verbosely log to the >> Application Log on the server? Replication stuff goes to a table, jobs >> go to tables, etc. I would like to centrally capture them all so my >> monitoring tool can just go to a single place. >> >> Thanks. >>
Only, Severity Level of over 19 messages are loged to the Application Log by default. You can also use WITH LOG when calling RAISERROR in your database applications to save the errors in the Application Log. -- Ekrem Önsoy "Co Co Net" <coconet@community.nospam> wrote in message news:af34949u63bi1oughdp6l4ckent47jsf0a@4ax.com... > > Some things like Replication are logged to a table. I would like the > same thing to be written to the Event Log. Isn't there a way to make > SQL Server operations go to the Application Event Log? > > > > On Mon, 21 Jul 2008 11:11:01 -0700, Linchi Shea > wrote: > >>If the tools are not writing to the app eventlog and can't be configured >>to >>do so, you would have to trap the errors yourself, and write them to the >>app >>eventlog yourself. >> >>Linchi >> >>"Co Co Net" wrote: >> >>> How can I make all services and jobs and etc verbosely log to the >>> Application Log on the server? Replication stuff goes to a table, jobs >>> go to tables, etc. I would like to centrally capture them all so my >>> monitoring tool can just go to a single place. >>> >>> Thanks. >>>
