Wednesday, March 28, 2012

Multi Server Job Activity Monitor Possible or Not?

Hi,
I am using SQL Server Management Studio to manage both 2000 and 2005
servers. I would like to see a Job Activity Monitor window that covers all
servers. Is it possible to this?
We check all the scheduled jobs have completed successfully on each server
each day any suggestions best practice for doing this will be most welcome.
Many Thanks,
Paul.
You should look at SQL Sentry Event Manager.
http://www.sqlsentry.net/
Aaron Bertrand
SQL Server MVP
"Paul" <PaulC@.newsgroups.nospam> wrote in message
news:95366CF2-A6E4-4E6A-B8B7-8432CF4A8E9E@.microsoft.com...
> Hi,
> I am using SQL Server Management Studio to manage both 2000 and 2005
> servers. I would like to see a Job Activity Monitor window that covers all
> servers. Is it possible to this?
> We check all the scheduled jobs have completed successfully on each server
> each day any suggestions best practice for doing this will be most
> welcome.
> Many Thanks,
> Paul.
>
|||I second Aaron's suggestion. If you have multiple servers and want to
monitor, schedule and get overall control of the jobs across them there is
no better tool on the market.
Andrew J. Kelly SQL MVP
"Paul" <PaulC@.newsgroups.nospam> wrote in message
news:95366CF2-A6E4-4E6A-B8B7-8432CF4A8E9E@.microsoft.com...
> Hi,
> I am using SQL Server Management Studio to manage both 2000 and 2005
> servers. I would like to see a Job Activity Monitor window that covers all
> servers. Is it possible to this?
> We check all the scheduled jobs have completed successfully on each server
> each day any suggestions best practice for doing this will be most
> welcome.
> Many Thanks,
> Paul.
>

No comments:

Post a Comment