Schedule Report to run last day of month.

Hello Howard Jennings

Last of every month, can also be considered as Starting of the month. 

0 0 1 * * - On the hour; 12:00am; 1st

This executes on 1st of every month, at 12 AM

If this doesn't satisfy you, then you probably has to create 4 schedulers.

1. Execute at every 31st day (of these months) - 0 0 31 1,3,5,7,8,10,12 * - On the hour; 12:00am; 31st; January and March and May and July and August and October and December

2. Execute at every 30th day (of these months) 0 0 30 4,6,9,11 * - On the hour; 12:00am; 30th; April and June and September and November

3. Execute at 29th of Leap year of Feb - This can be ignored if the step 4 is set

4. Execute at 28th of non leap year of Feb - 0 0 28 2 *

This is just an idea!!

Best Regards,
Sravanthi B

Hello Howard Jennings

Last of every month, can also be considered as Starting of the month. 

0 0 1 * * - On the hour; 12:00am; 1st

This executes on 1st of every month, at 12 AM

If this doesn't satisfy you, then you probably has to create 4 schedulers.

1. Execute at every 31st day (of these months) - 0 0 31 1,3,5,7,8,10,12 * - On the hour; 12:00am; 31st; January and March and May and July and August and October and December

2. Execute at every 30th day (of these months) 0 0 30 4,6,9,11 * - On the hour; 12:00am; 30th; April and June and September and November

3. Execute at 29th of Leap year of Feb - This can be ignored if the step 4 is set

4. Execute at 28th of non leap year of Feb - 0 0 28 2 *

This is just an idea!!

Best Regards,
Sravanthi B

There are a couple of things that you can do with the schedulers. Using the scheduler's advanced options, you can set up three separate jobs.

55 23 30 4,6,9,11         55 23 31 1,3,5,7,8,10,12  55 23 28 2               

0 0 1 * * 

Hi Sravanthi

Thanks very much for your reply, I'm glad it looks like there's a way. Where do I enter the numbers you've given?

Thanks

Howard

I'd like to thank everyone for contributing so quickly and helping me resolve my issue.

Thank you Sravanthi Bellamkonda, Rolustech Support & @Patrick McQueen.

While configuring a scheduler, this setting can be done at the interval field that you see. You should have to be entered as 5 input values hence I have given 5 numbers accordingly.

surveyforcustomers

While configuring a scheduler, this setting can be done at the interval field that you see. You should have to be entered as 5 input values hence I have given 5 numbers accordingly.

surveyforcustomers

However, there is a problem with this. This will run on the 28th of February even on the leap years as well. If that is a problem for you, you will need to find another way.

However, a significantly better approach would be that you set up a job/scheduler to run on the 1st of every month.

 krogerexperiencee

However, there is a problem with this. This will run on the 28th of February even on the leap years as well. If that is a problem for you, you will need to find another way.

However, a significantly better approach would be that you set up a job/scheduler to run on the 1st of every month.

 krogerexperiencee