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, 'test1@test.com' PARAMETER1, 'test2@test.com' PARAMETER2, 'no-reply@test.com' PARAMETER3, 'Test - Populate Bursting Email Address' PARAMETER4, 'Hi this is a test of the Bursting email address definition.' PARAMETER5, 'true' PARAMETER6, 'no-reply@test.com' PARAMETER7 ,NULL "PARAMETER8" -- not used ,NULL "PARAMETER9" --not used ,NULL "PARAMETER10" -- not used from dual
0