I currently have tasks that run on the last day of the month (i.e. month end sales reports, etc). We are moving from a "normal" calendar to a variation of the 4-4-5 calendar. This means the month end date could fall anywhere from the 23rd of the month through the 4th day of the following month.

I have setup a sql table with the period start and end dates. Is there a way to query the sql table to set the trigger/next trigger dates?

Thanks,
John

Not right now. You need to write this logic yourself with the VisualCron API. I am moving this topic to Feature requests.

---

I think I have figured out a way to do what I need. My sql table consists of various fields but specifically a field called "period-end". I created a job which runs at 12:30 a.m. each morning and the first task queries the sql database like this:

SELECT
CASE WHEN GETDATE() = period_end THEN 'TRUE' else 'FALSE' END AS EOM
FROM fiscalcalendar445
WHERE GETDATE() BETWEEN period_start AND period_end

I save the output to a variable which I can then use to trigger the rest of the tasks associated with the month end job.

Thanks for the feedback!

---