How can i call schedule job data in email script

[Rama26]

Hi All,

below is the script written in schedule job.

var info = new GlideRecord('u_cam_account');

info.addQuery('u_active', 'true');

info.addQuery('u_cloud_provider', 'aws');

info.query();

while (info.next()) {

    var cp = info.u_account_id;

    var innerInfo = new GlideRecord('u_cam_account');

    innerInfo.addQuery('u_account_id', cp);

    innerInfo.query();

    if (innerInfo.next()) {

        var division = innerInfo.u_division.getDisplayValue();

        var accountemail = innerInfo.u_account_owner.email;

    }

}

var innerInfo1 = new GlideRecord('u_cloud_account');

innerInfo1.addQuery('u_aws_account_id', cp);

innerInfo1.query();

if (innerInfo1.next()) {

    var division1 = innerInfo1.u_hier2.getDisplayValue();

    var accountemail1 = innerInfo1.u_account_owner.email;

}

if (accountemail1 == accountemail) {

    if (division1 != division || bu1 != bu || env1 != env) {

       gs.eventQueue('test.event.test', current, accountemail);

    }

} 

based on script it's working fine.  but how can send data (division, division1) in table format on email.

[Kieran Anson]

gs.eventQueue allows for two event params to be sent. I'd suggest creating an object of the data you want, and then passing it in as the fourth param

gs.eventQueue('test.event.test' , info , accountemail , yourDataObject)