Trouble sending e-mail from scheduled job

[Mike Hashemi]

I have been asked to write a script, which will be schedule to run periodically. The script will search for all active contacts associated with a specific customer account, where the "location" field is blank. Ultimately, that list needs to be e-mailed to an external e-mail address.

I have created a script, job, event registration, and notification. When I execute the job, I can see that it runs because I have it sending gs.info() messages but I do not see any e-mail in the outbox (I am running this in Dev right now).

What am I missing? Here is what I have so far (please note that the message in "What will it contain" is not final):

Script:

// Select a random number and use it to track the sequence of log messages in this script.
var seq = Math.floor(Math.random() * 999999) + 1;

gs.info('[{0}]GetContacts: Beginning "User list - no location" scheduled job.', seq++);

// #region Initialize variables
var account = 'bb8083d14755f910291fe0e8036d43ea'
var userList = [];
// #endregion Initialize variables

// #region Get contacts
gs.info('[{0}]GetContacts: Query for contacts contacts at {1}.', seq++, account);
var grContact = new GlideRecord('customer_contact');
grContact.addEncodedQuery('account=' + account + '^user_nameISNOTEMPTY^locationISEMPTY^active=true');
grContact.query();

while (grContact.next()) {
    //gs.info('[{0}]GetContacts: Adding {1} to the list.', seq++, grContact.getValue('user_name'));

    userList.push(grContact.getValue('user_name'));
}

gs.info('[{0}]GetContacts: There are {1} contacts.', seq++, userList.length);
// #endregion Get contacts

// #region Trigger event
gs.eventQueue('send.genericemail', null, 'testuser@domain.com', userList.length);
// #endregion Trigger event

Event registration:

Notification:

[James Chun]

Hi @Mike Hashemi,

Have you verified if the events are created and processed in the event queue [sysevent_list] table?

Also, can you update the following in the notification record:

• Enable the Send to event creator field
• Replace the ${parm2} in the Message HTML field to ${event.parm2} 

Cheers

Cheers

[Mike Hashemi]

I can confirm that I see "send.genericemail" in the sysevent list, at the time I expect to see it (a few seconds after I execute the scheduled job) and I saw it switch from "ready" to "processed".

As requested, I also add a checkmark to "Send to event creator" and swapped the parm2 variable for ${event.parm2} (${parm2} is what SN inserted when I selected the variables from the "Fields" list). 

There is still no message to me in sys_email. I checked Sent, Skipped, and Failed too, but the message is not in any of those either.

[James Chun]

Thanks, can you try doing a preview of the notification via an event that is already processed?

It could give us more info on why it's failing to be sent, my guess is that it could be an invalid recipient or something else.

[Mike Hashemi]

Yeah, looks like it is not seeing parm1 or parm2: