Thanks for the info Cintia, I guess I need to figure out how to run a Shell Script to access the DB on the server I'm testing, then deliver the results back to a centralized DB on a trusted domain.
If anyone in the community has something like this already and could give a hint, that would be appreciated.
------------------------------
Freddie Callander
------------------------------
Original Message:
Sent: Mon June 24, 2024 08:50 AM
From: Cintia Ogura
Subject: DMC - Save Job result data to DMC repo
Hello Freddie,
Unfortunately we don't save result data from a job into the repository database.
That could affect the repository database size and performance, as we don't know how much data is returning by a job.
I hope that helps!
------------------------------
Cintia Ogura
Original Message:
Sent: Mon June 24, 2024 01:46 AM
From: Freddie Callander
Subject: DMC - Save Job result data to DMC repo
Is there any way to save the result data from a job into the repository? I have 130 databases being monitored by one DMC instance and need to grab data from each database that is not housed in the profile properties table. There are other queries that I would like to run on multiple databases and centralize the data returned. I have not been able to figure out how to push everything back into the central repository from each database.
If anyone has developed a way to do this and be able to share it, that would be great.
Thanks
------------------------------
Freddie Callander
------------------------------