Oracle: DBA_AQ_AGENTS

select
   agent_name,
   http_enabled,
   smtp_enabled
from
   dba_aq_agents;