September 8, 2023 at 9:16 am
From the server which is registered as a Central management server(CMS) can I create a SQL job(automate it) in that server(CMS) which then will extract data from all the registered servers under the CMS and dump that data into the CMS server/database.? Is this possible ?
When I run a select query in the CMS ... DatabaseEngineServerGroup.master is what under the query is running against. Attached screenshot.
September 8, 2023 at 11:03 am
You can set up connections to create objects in msdb, or run sp_addjob, et al, from your CMS. This just runs scripts across all your connections.
September 8, 2023 at 11:32 am
Can you please elaborate on this or provide any links for the same.Thanks
September 18, 2023 at 7:23 pm
Sorry, I misread your post thinking you were sending jobs through the CMS. You want to run stuff on your CMS to all servers automatically from a job. AFAIK, this isn't possible.
September 19, 2023 at 8:01 am
Could do it in PowerShell and DBATools, call Get-DbaRegServer, loop round the result set from that and call Invoke-DbaQuery, write the result set to the CMS server.
But directly in SSMS no, unless you write a SSIS package or something to again loop round the servers and ETL the data you need into the CMS
September 26, 2023 at 4:32 am
SSIS - Yes. I already do that.
But wanted to check if this can be done with Registered servers.
September 26, 2023 at 8:20 am
No cannot be done in SSMS with registered servers
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply