Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm looking for a tool or low-overhead way to automatically document scheduled SQL agent jobs across about 20 MS SQL 2005 servers. There are various jobs which run periodically as well as nightly backups; during the day the servers are accessible to users for manual queries.

Basically, everything is bumping into everything else. Ideally, I'd like to find some kind of tool which looks at all the scheduling data across all the severs and generates a calendar based report. I'm wondering if anyone has seen anything like this? I've got the RedGate suite, and their SQLDoc tool doesn't seem to do this in a particularly useful way.

Any ideas?

share|improve this question

3 Answers 3

Check out SQL Sentry's Event Manager:

http://sqlsentry.com/event-manager/sql-server-job-scheduler-enterprise.asp

I don't work for them - I actually work for a competitor - but it's a really nice product from what I've seen, and I've heard good things from other users.

share|improve this answer
    
SQLSentry is the best tool for this if you can get the budget. They resell this tool to Idera. –  Steve Jones Jun 4 '09 at 15:16

first shot, try IDERA, they have a free tool called Job Manager that is a lite version of a paid product - it only allows connection to max of 20 servers. www.idera.com. It allows editing of job properties and drag and drop schedule changes. The interface is simple and gives a really good snapshot of your job execution history with the option to drill in to get error details.

We have RedGate SQL Response as our main SQL Server health monitor. Its got a free 14 day trial option.

I'm sure there are more that are just as good but I have not experienced any of the current version from other providers

share|improve this answer

Check this out, from SQL Mag - Creating a Job Scheduling Advisor.

http://www.sqlmag.com/Article/ArticleID/100664/sql_server_100664.html

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.