June 16, 2010 at 4:42 am
if i am handling 150 servers then how to check the active jobs of all the servers can any one help me
June 16, 2010 at 6:46 am
June 16, 2010 at 8:36 am
Nils Gustav Stråbø (6/16/2010)
There are many tools "out there". Some free and some expensive.SSC just had an article about inventory tools. Check it out : http://www.sqlservercentral.com/articles/Administration/70129/[/url]
nils,
Just trying to figure out how the above link is related to original question posted by Reddy ?
SQL DBA.
June 16, 2010 at 8:50 am
Sorry, I meant to tell him to read the discussion related to the article, but that information slipped.
There are many suggestion in the discussion regarding monitoring tools for SQL Agent jobs (and more).
June 16, 2010 at 8:52 am
You can run multi-server queries with SSMS.
It's not the same as monitoring with the Job Monitor, but you can get the information in a result set.
-- Gianluca Sartori
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply