Email Bursting not working
I have the below Email bursting definition configured. The Schedule job completes successfully, however I never actually receive an email from it, even though there was data to fetch.
I've tried this first as passing the TO email address as a Parameter from the Data Model, and even hard-coding an email address below does not deliver the email to the intended address.
Is this bursting query formatted with the required columns, and is there anything else I can check?
select 'H' as "KEY", 'output7' TEMPLATE, 'en-US' LOCALE, 'Text' OUTPUT_FORMAT, 'EMAIL' DEL_CHANNEL, '[email protected]' PARAMETER1, '[email protected]' PARAMETER2, '[email protected]' PARAMETER3, 'Test - Populate Bursting Email Address' PARAMETER4, 'Hi this is a test of the Bursting email address definition.' PARAMETER5, 'true' PARAMETER6, '[email protected]' PARAMETER7 ,NULL "PARAMETER8" -- not used ,NULL "PARAMETER9" --not used ,NULL "PARAMETER10" -- not used from dual