Comments
-
Yes, you can. You can do anything you like with the data within the dpa database, as long as you can figure out how to query it. Simply setup an agent job against the dpa database and send this info to you. If your dpa database is an azure sql db, then use a runbook or elastic jobs to run this on against it on a schedule…
-
I was also attempting to figure out a way to add this alert, and it took me a while to figure it out. Here is what I had to do in the end to figure this out. Method 1: I used this first but did not like it. Run a query against the dpa repo to see if any database is in a state that is not "start". I didn't like this method…