Schedule: Last Business Day of the Month

Jim G. (13 posts)
January 30, 2025 01:25 PM
Accepted Answer

I've tried to set up a schedule to run a job on the last business day of the month, but to no avail. For some reason, my schedule keeps skipping May 30th, 2025.

 

Can someone please specify steps for a schedule that runs jobs on the last business day of each month?

Bill Staff (603 posts)
January 30, 2025 02:01 PM
Accepted Answer

To do this, add a day rule using "Days specified using a floating rule" set to 0 days after the 31st/Last occurrence of selected weekdays. Select all months. Select Monday-Friday and check Exclude Holidays.

Click OK twice to get back to the Schedule Trigger Properties window, then go to the Holidays tab. Select the holiday set you want to use but set the rule to "Run as scheduled" (this is important; see the Holidays section of the Date Rule Properties help topic for more information).

Note: If you use the "Show matching dates" option in the Execution Schedule properties window, it may not factor in holidays until you have saved the job and come back in.