Do we need a script condition to schedule on the first business day of the month?

Josh102
Kilo Guru

I want to schedule jobs to run on the first business day of each month, so if the 1st of a month falls on a Saturday then it should trigger on the Monday the 3rd.

After searching on the forums it seems like this is the simplest solution. I'll be using it for now as it is simple and works, but it just seems like we should have a way to select a business calendar option from the UI rather than needing to use a script condition.

It feels like I'm missing something, especially since 'Business Calendar: Entry Start' is an option, I just can't see a way to specify working days only.

1 ACCEPTED SOLUTION

Mark Manders
Mega Patron

Unfortunately on some points you just have to deal with the 'it seems like we should have .....' when working with ServiceNow. It can do a lot, but not everything. And most things can be taken care of via workarounds, as you already found out. You can check the idea portal if there's already an entry for this suggestion and upvote it, or create your own idea and hopefully it will become product functionality.

And yes: you can search for hours, but you won't find a way to check on just working days OOB.

 

If my answer helped you in any way, please then mark it as helpful.

Mark


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

4 REPLIES 4

Mark Manders
Mega Patron

Unfortunately on some points you just have to deal with the 'it seems like we should have .....' when working with ServiceNow. It can do a lot, but not everything. And most things can be taken care of via workarounds, as you already found out. You can check the idea portal if there's already an entry for this suggestion and upvote it, or create your own idea and hopefully it will become product functionality.

And yes: you can search for hours, but you won't find a way to check on just working days OOB.

 

If my answer helped you in any way, please then mark it as helpful.

Mark


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Thanks for the response. I might have a look through the idea portal and see if I can find anything. Good to get clarification that this wasn't a documented process that I was somehow missing.

Musab Rasheed
Tera Sage
Tera Sage

Hello,

You have to bring a field on form 'Business calendar' and then explore table 'Business calendars' and see if that works, there is no proper documentation for this but give a try otherwise stick to existing solution and also submit idea in Idea portal to make this process simpler.

Idea portal : https://community.servicenow.com/community?id=ideas_list&sysparm_module_id=enhancement_requests

Business calendar : https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/time/task/define-business-calendar-entries.html

Please hit like and mark my response as correct if that helps

Regards

Please hit like and mark my response as correct if that helps
Regards,
Musab

Brian Lancaster
Tera Sage

I have the same requirement. I was thinking of use flow instead of a scheduled job. I will run the flow in the first of the month and using a custom action to determine the day of the week I could then continue or use a wait for 24-48 hours depending on it falling on a Saturday or Sunday.