Check DBMail - ExternalMailQueue availability in msdb.sys.service_queues

[deffinity]

Feature Request

To check if DBMail is enabled and supposed to be working.

Checking sys.configuration, mail profiles exist etc. is good but not enough.
Additional check that returns 1 if DBMail seems to work:

SELECT  is_activation_enabled & is_receive_enabled & is_enqueue_enabled
FROM msdb.sys.service_queues
WHERE name = 'ExternalMailQueue'

If return is 0 no messages can be sent through DBMail.