i created this Scheduled Script Execution but it seem like its not triggering

[Ricardo Sanchez]

The purpose it needs to send an approval reminder 24, 48 and 72 hours if no respond on the 96 hour it will close the req and RITM. 

(function () {

  var RITM_STATE_CLOSED_INCOMPLETE = 4;                 // sc_req_item.state

  var RITM_STAGE_VALUE            = 'approval_not_received'; // sc_req_item.stage

  var REQ_REQUEST_STATE_VALUE     = 'closed_incomplete';     // sc_request.request_state

  var REQ_STAGE_VALUE             = 'closed_incomplete';     // sc_request.stage

  function makeBounds(hoursAgo) {

    var now = new GlideDateTime();

    var msNow = now.getNumericValue();

    var upper = new GlideDateTime();

    upper.setNumericValue(msNow - (hoursAgo * 60 * 60 * 1000));

    var lower = new GlideDateTime();

    lower.setNumericValue(upper.getNumericValue() - (60 * 60 * 1000));

    return { lower: lower, upper: upper };

  }

  // Send approval reminders to approvers on RITMs at a given age

  function queueRitmReminders(hoursAgo, eventName) {

    var w = makeBounds(hoursAgo);

    var gr = new GlideRecord('sysapproval_approver');

    gr.addQuery('state', 'requested');

    gr.addQuery('sysapproval.sys_class_name', 'sc_req_item'); // RITM only

    gr.addQuery('sys_created_on', '>=', w.lower);

    gr.addQuery('sys_created_on', '<',  w.upper);

    gr.query();

    while (gr.next()) {

      gs.eventQueue(eventName, gr, '', '');

    }

  }

  // At 96 hours, close RITM and REQ as incomplete, cancel remaining approvals, fire cancellation event

  function cancelRitmsAt96Hours() {

    var w = makeBounds(96);

    var appr = new GlideRecord('sysapproval_approver');

    appr.addQuery('state', 'requested');

    appr.addQuery('sysapproval.sys_class_name', 'sc_req_item');

    appr.addQuery('sys_created_on', '>=', w.lower);

    appr.addQuery('sys_created_on', '<',  w.upper);

    appr.query();

    // Prevent double handling when multiple approvals exist on the same RITM in this window

    var processed = {};

    while (appr.next()) {

      var ritmId = String(appr.getValue('sysapproval') || '');

      if (!ritmId || processed[ritmId]) continue;

      processed[ritmId] = true;

      var ritm = new GlideRecord('sc_req_item');

      if (!ritm.get(ritmId)) continue;

      // Skip if already closed incomplete

      if (String(ritm.getValue('state')) === String(RITM_STATE_CLOSED_INCOMPLETE)) continue;

      // Set RITM stage

      if (ritm.isValidField('stage')) {

        ritm.setValue('stage', RITM_STAGE_VALUE);

      }

      // Close RITM as incomplete

      ritm.setValue('state', RITM_STATE_CLOSED_INCOMPLETE);

      ritm.update();

      // Cancel any still requested approvals on this RITM

      var ap2 = new GlideRecord('sysapproval_approver');

      ap2.addQuery('sysapproval', ritm.getUniqueValue());

      ap2.addQuery('state', 'requested');

      ap2.query();

      while (ap2.next()) {

        ap2.setValue('state', 'cancelled');

        ap2.update();

      }

      // Close parent REQ request_state and stage

      if (ritm.request) {

        var req = new GlideRecord('sc_request');

        if (req.get(ritm.request.toString())) {

          if (req.isValidField('request_state')) {

            req.setValue('request_state', REQ_REQUEST_STATE_VALUE);

          }

          if (req.isValidField('stage')) {

            req.setValue('stage', REQ_STAGE_VALUE);

          }

          req.update();

        }

      }

      // Firing cancellation event on the RITM table

       gs.eventQueue('ritm.approval.cancelled.96h', ritm, '', '');

    }

  }

  // Reminders

  queueRitmReminders(24, 'ritm.approval.reminder.24h');

  queueRitmReminders(48, 'ritm.approval.reminder.48h');

  queueRitmReminders(72, 'ritm.approval.reminder.72h');

  // Auto cancel at 96 hours

  cancelRitmsAt96Hours();

})();

[Bhimashankar H]

Hi @Ricardo Sanchez ,

What is scheduled job frequency  and is scheduled job active?

Share screenshot of SJ

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!

[Ricardo Sanchez]

[Bhimashankar H]

Did you tried on execute now and does sends any notifications?

Before execute now, add some log statement in each function that get you idea that function got called and make sure you have data in that time range and check the logs once executed.

Thanks,
Bhimashankar H

[Bhimashankar H]

Hi @Ricardo Sanchez ,

Did you get a chance to try logging the statements? and execute now

Thanks,
Bhimashankar H

-------------------------------------------------------------------------------------------------
If my response points you in the right directions, please consider marking it as 'Helpful' & 'Correct'. Thanks!