You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

how to create recurrence for last day of each month using process schedular

4 replies [Last post]
knaveen.ps's picture
User offline. Last seen 8 years 9 weeks ago. Offline
Joined: 03/19/2012
Posts: 1

Hi everyone !!!!!!
I am very new to peoplesft ,
wanted to create recurrence to run sqr program for the last day of each month !!!!
How to create it?
can please anybody help me ??

Thanks and Regards,
naveen

Ashar's picture
User offline. Last seen 4 years 13 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: how to create recurrence for last day of each month ...

Hello,

You cannot create a recurrence with such pattern using Recurrence Definition. You can run the SQR to run on a particular date of every month (eg: run the SQR on 25th of every month). However it is not possible to configure the recurrence to run on last day of the month.

One work around would be to create a recurrence definition with a specific date in particular month and update the date in recurrence definition using the same SQR so that it is updated to correct last date of next month.

Vrao Polavarapu's picture
Vrao Polavarapu (not verified)
Re: how to create recurrence for last day of each month ...

You can try using recurrance pattern as "Monthly" and set "Day of Month" to 31. System automatically does this.

Ashar's picture
User offline. Last seen 4 years 13 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: how to create recurrence for last day of each month ...

Would that work? as 31 need not be the last day of every months..

Ashar's picture
User offline. Last seen 4 years 13 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: how to create recurrence for last day of each month ...

You are right. Apparently PeopleBooks says, "The system automatically adjusts for the varying number of days in each month."