Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jordy
Starting Member
5 Posts |
 Posted - 2011-12-20 : 21:10:56
|
| Hi guys, This is my first post in any forum. So if I am messing up and posting in the wrong area etc let me know.I am a new DBA. Our company has many SQL Server instances which I have discovered using MAP. What I now want to do is try and view (in a central location) all my instance maintenance plan jobs so I can see what we have currently setup, running, not running, what schedules they have etc.I thought perhaps there might be a DMV or tool to assist me with this. However I have not managed to find one.Any suggestions or ideas around how I could achieve this would be appreciated. CheersB |
|
|
Sachin.Nand
2937 Posts |
Posted - 2011-12-21 : 00:58:17
|
| Register your instances in central management server and then query the sysjobs table in msdb database for the list of all the jobs that running on the registered instances.PBUH |
 |
|
|
Jordy
Starting Member
5 Posts |
Posted - 2012-01-09 : 20:53:12
|
| Thanks Sachin, appreciate your feedback. Just to give you an idea of what I am looking to do: I want to know what sql instances we have and a few basic details. Then as I said above keep a track of what maintenance plans or jobs that are running. I am using SQLPing to find my sql instances and then will look into central server manager solution.Cheers |
|
|
|
|
|
|
Viewing multipul server maintenance plans