Trouble sending e-mail from scheduled job

Mike Hashemi · ‎05-28-2024

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:

Mike Hashemi · ‎05-31-2024

Turns out that the notification was in a non-global domain. I am not sure why that would cause this issue, but I:

Exported the notification's record to XML
Updated the domain and domain path fields
Imported the XML
Ran the scheduled job

This time, the e-mail was sent. This is the script I ended-up using:

// 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 "Get change notification contacts" action in the "Change notification message" flow.', seq++);

// #region Initialize variables
var account = 'bb8083d14755f910291fe0e8036d43ea';
var recpients = 'user1@domain.com,user2@domain.com';
var userList = [];
// #endregion Initialize variables

// #region Get contacts
gs.info('[{0}]GetContacts: Query for active contacts contacts with no location, 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} matching contacts.', seq++, userList.length);
// #endregion Get contacts

// #region Trigger event
if (userList.length > 0) {
    var userListStr = userList.join('\n');
    gs.info("Triggering event to send e-mail.");
    gs.eventQueue('send.genericemail', null, recpients, userListStr);
}
// #endregion Trigger event

View solution in original post

SanjivMeher · ‎05-29-2024

userList.length will give you the length of the array. and userList.toString() will list all the user names.

Did you also get a chance to check the event log to see if the event was generated?

Please mark this response as correct or helpful if it assisted you with your question.

Mike Hashemi · ‎05-29-2024

Yes, I see the event being triggered a couple of times today:

There is nothing in sys_email with any of the expected recipients.

SanjivMeher · ‎05-29-2024

Do you see any error in the system logs?

Also in the email, you are suppose to use ${event.parm2} instead of ${parm2}

Please mark this response as correct or helpful if it assisted you with your question.

James Chun · ‎05-29-2024

Looks like the notification is set correctly, maybe all the recipients have notifications disabled?

Do you see anything in the outbox other than this notification?

Mike Hashemi · ‎05-29-2024

Yeah, there are lots of items in the outbox. There is on recipient "receiving" lots of stuff in the outbox, so I added them to my notification and re-ran the job. No luck, my e-mail still does not show up.