Schedule Chores to run only certain days?

Post Reply
erik664
Posts: 18
Joined: Fri Mar 08, 2013 6:11 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007

Schedule Chores to run only certain days?

Post by erik664 »

Hello, and thanks in advance.

It doesn't seem possible to me to schedule a chore so that it runs on only certain days. I would like to schedule a chore to run only Monday-Friday, and not on Saturday and Sunday.

Is there any way to accomplish that? The only way I can think of is to make multiple copies of the same chore for each day, and set them to run every week. Is there a more elegant solution?

Thanks,
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Schedule Chores to run only certain days?

Post by Alan Kirk »

erik664 wrote:It doesn't seem possible to me to schedule a chore so that it runs on only certain days.
Correct.
erik664 wrote:I would like to schedule a chore to run only Monday-Friday, and not on Saturday and Sunday.

Is there any way to accomplish that? The only way I can think of is to make multiple copies of the same chore for each day, and set them to run every week. Is there a more elegant solution?
The other way of doing it is to put in the Prolog of the first process some code to check what the day of the week is, and to quit the chore if it's Saturday or Sunday. For the way of determining the day of week, see the heading "To Get The Weekday Of A Date As A Value" in this article.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
erik664
Posts: 18
Joined: Fri Mar 08, 2013 6:11 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007

Re: Schedule Chores to run only certain days?

Post by erik664 »

Thanks Alan,

The code you linked to in the other thread is perfect. That was exactly the kind of solution I had in mind.
Post Reply