To periodically check the status of an API and see if the connected database is down for maintenance, the Ops team should use API Functional Monitoring:

API Functional Monitoring:

API Functional Monitoring allows you to set up scheduled tests and monitor the functional performance of your APIs. It can be configured to periodically make API calls and check for specific conditions, such as whether the database is down for maintenance.

Scheduled API Calls:

Set up the necessary tests within API Functional Monitoring to periodically call the API and verify its status. These tests can be scheduled to run at regular intervals.

View Status History:

API Functional Monitoring provides a dashboard where you can view the history of these tests, including their results and any failures. This helps in tracking the availability and performance of the API over time.

References:

MuleSoft API Functional Monitoring Documentation