Details about this thread
  • State Verified Answer
  • Replies 16 replies
  • Subscribers 310 subscribers
  • Views 3632 views
  • Users 0 members are here
Related content from around SugarClub

Schedule Report to run last day of month.

Howard Jennings

I need to run a report after close of business on the last day of every month. eg. at 9pm. How do I set up a schedule to do it?

can I set a workflow to run a report?

Can I add a new entry in the schedule dropdown list

Or create a formula that will trigger it to run?

There is an enhancement request for this feature going back to 2011, so I guess the powers that be don't think it's worth doing.

Parents
  • 0

    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

  • 0 in reply to Sravanthi Bellamkonda
    Hello Howard,

    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              

     

    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.

    0 0 1 * *

    I hope this helps.

    If you have any other issues, just get in touch with us at support@rolustech.com. 

Reply
  • 0 in reply to Sravanthi Bellamkonda
    Hello Howard,

    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              

     

    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.

    0 0 1 * *

    I hope this helps.

    If you have any other issues, just get in touch with us at support@rolustech.com. 

Children
No Data