How should I configure my scheduler to make sure it's runing the last day of every month, whether it's 30/31 days or 28/29 in February.
Will 31 as an N-th day do the job ?
Much thanks for your help.
Your answer helped me achieve the following solution for my need :
1. 4 Schedulers that will run monthly on the 28/29/30/31 days of the month.
2. Used my main query to add lastday of the month as an additional data :
@LastDayOfMonth = DateOnly(SubMinutes(AddMonths(YearAndMonth(GetDate()), 1), 1))
3. Check >In split if @LastDayOfMonth = DateOnly(GetDate()) yes? proceeds to send my delivery else end workflow