SQL Agent job monitoring

#1

I have multiple SQL servers and I have Jobs that run everyday to do
various tasks.

Is there a 3rd party app or something that would collect the output of
the activity log and put it in a central location. Something like
forwarding to a syslog. I would like to collect if the job failed.
Having emails on every server sending messages is kind of messy.

#2

How about SQL Sentry's Event Manager?

http://sqlsentry.net/event-manager/s...enterprise.asp

On 1/7/10 11:15 AM, in article
de9fce37-c16d-4787-8f9b-e3c935becce2...oglegroups.com,
"Barrycuda" <barrycuda72 (AT) gmail (DOT) com> wrote:

Quote:

I have multiple SQL servers and I have Jobs that run everyday to do
various tasks.

Is there a 3rd party app or something that would collect the output of
the activity log and put it in a central location. Something like
forwarding to a syslog. I would like to collect if the job failed.
Having emails on every server sending messages is kind of messy.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL Agent job monitoring

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

SQL Agent job monitoring - 01-07-2010 , 10:15 AM

Re: SQL Agent job monitoring - 01-13-2010 , 02:51 PM