tracker issue : CF-4201628

select a category, or use search below
(searches all categories and all time range)
Title:

schedule - unable to schedule end of the month (monthly) job

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/Fixed

Reporter/Name(from Bugbase): Rastislav Toscak / Rastislav Toscak ()

Created: 03/20/2018

Components: Scheduler

Versions: 11.0

Failure Type: Usability Issue

Found In Build/Fixed In Build: 11,0,13,303668 / latest documentation.

Priority/Frequency: Normal / All users will encounter

Locale/System: ALL / Win 2012 Server x64

Vote Count: 0

Problem Description:Trying to schedule a monthly job to run at the last day of each month. Based on your explanation (read below) if I scheduled a job for Sep 30th the job would run each month on 30th and Feb 28th or 29th. That didn't happened. Job ran on Jan 30 and the next was scheduled for Mar 30th.

Your explanation:

https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-r-s/cfschedule.html

"If you schedule a job to run monthly on any date in the range 28-31, the scheduler does the following:

If you schedule a monthly job to run on the last day of a month, the scheduled job will run on the last day of each month. For example, if you schedule a monthly job to start on January 31, it will run on January 31, February 28 or 29, March 31, April 30, and so on.
If you schedule a monthly job to run on the 29th or 30th of the month, the job will run on the specified day of each month for 30 or 31-day months, and the last day of February. For example, if you schedule a monthly job to start on January 30, the job will run on January 30, February 28 or 29, March 30, April 30, and so on."

Steps to Reproduce:Simply create a job for Jan 30th. Let it run and the next scheduled job is Mar 30th. The same is fully true for any dates. Ex if scheduled for Mar 31st and ran then next run is May 31st and NOT April 30th as is supposed to.

Actual Result: next scheduled job is Mar 30th

Expected Result: next scheduled job is Feb 28th

Any Workarounds:Schedule the job to run on 1st every month just after midnight... if this can be called a work around.

Attachments:

Comments:

Running a task at the last day of every month is a complex schedule which can be handled by CRON expressions only . We will get this removed from the documentation. A sample Cron Expression that can be used to run a task at the last day of every month at 10 AM : 0 0 10 L * ?
Comment by Suchika S.
44 | March 22, 2018 11:32:34 AM GMT
The documentation is fixed and hence closing this bug.
Comment by Suchika S.
29465 | August 10, 2018 12:41:43 PM GMT