Configure scheduler to run the last day of the month in ACS

Avatar

Avatar

anasso83525035

Avatar

anasso83525035

anasso83525035

24-09-2018

Hi,

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 ?

Thank you.

1578477_pastedImage_0.png

View Entire Topic

Avatar

Avatar

anasso83525035

Avatar

anasso83525035

anasso83525035

30-09-2018

Hi Amit_Kumar

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

1582480_pastedImage_3.png