Using schedule to run job only at certain times

[danenglish]

I'm trying to create a scheduled job that will run only at certain times.  In this case, I want it only to run weekdays, during business hours, and not on holidays.  All this job does is fire off an event that I can use to trigger a notification.

I've found some useful code, but it doesn't seem to be sticking to the schedule times, as I'm seeing the job kick off on weekends, etc.

Am I missing something?

checkInSchedule();

function checkInSchedule(){

var schedRec = new GlideRecord('cmn_schedule');

schedRec.get('8-5 weekdays excluding holidays');

if(typeof GlideSchedule != 'undefined')

var sched = new GlideSchedule(schedRec.sys_id);

var inSched = sched.isInSchedule(new GlideDateTime());

if(inSched){

return false;

}

else{

return true;

}

}

As always, any help is appreciated!

[Mwatkins]

I have seen people successfully use the Calendar field on the scheduled job form (sys_trigger table). By default every system has one calendar called "Mon thru Friday 9-5". You could modify the out-of-box one or create your own calendar if you like to be used by your scheduled job. The only thing that relies on the default calendar is the old (deprecated) SLA engine - unless you are running ServiceNow Express version that still uses the old SLA engine.

[danenglish]

I had actually just noticed that field recently, but it appears to be blocked out for existing jobs.   Can I somehow add the calendar to my existing job or do I need to re-create it?

[Mwatkins]

There is an ACL that blocks you from changing any fields on the sys_trigger record of a scheduled job that is based on a scheduled job definition from any of the tables that extend from the sysauto. Sorry if that is a confusing explanation. Basically it means you can't change a job from the sys_trigger table is the job is defined in a document in the sysauto tables (sysauto_report, sysauto_script, etc.)

/nav_to.do?uri=sys_security_acl.do?sys_id=cbfe0d80c310010091fefd251eba8ff3

function canWriteSysTrigger() {
       var docId = current.document_key + "";
       if (gs.nil(docId)) {
               return true;
       }

       var baseTable = GlideDBObjectManager.getAbsoluteBase(current.document + "");
       if (baseTable != "sysauto") {
               return true;
       }

       return false;
}
canWriteSysTrigger();

[Mwatkins]

I tried testing out your script with some sample date times and it appears that GlideSchedule.isInSchedule() works fine for me. I wonder what is going wrong in your case. Keep in mind that your script is returning "false" if the things are "in schedule" and if not then it returns "true". Maybe that logic is backward?

I ran the following in Scripts - Background:

function checkInSchedule(time){
var schedRec = new GlideRecord('cmn_schedule');
schedRec.get('8-5 weekdays excluding holidays');
if(typeof GlideSchedule != 'undefined')
var sched = new GlideSchedule(schedRec.sys_id);
var inSched = sched.isInSchedule(time);
if(inSched){
return false;
}
else{
return true;
}
}


var times = {
rightnow : new GlideDateTime(),
tomorrow : new GlideDateTime(),
yesterday : new GlideDateTime(),
twoDaysAgo : new GlideDateTime()
}


times.tomorrow.addDays(1);
times.yesterday.addDays(-1);
times.twoDaysAgo.addDays(-2);


var days = ["", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun"];


for (time in times) {
gs.print(time + ", " + days[times[time].getDayOfWeek()] + " " + times[time] + " is in schedule: " + checkInSchedule(times[time]));
}

Here is the output:

[0:00:00.196] Script completed in scope global: script
*** Script: rightnow, Mon 2017-04-24 17:24:24 is in schedule: false
*** Script: tomorrow, Tue 2017-04-25 17:24:24 is in schedule: false
*** Script: yesterday, Sun 2017-04-23 17:24:24 is in schedule: true
*** Script: twoDaysAgo, Sat 2017-04-22 17:24:24 is in schedule: true