Scheduling chores at a specific date

[appleglaze28]

Is there anyway to schedule chore on specific date especially for like data load or ODBC output? If you are required to upload or load data at a specific date. Currently, your only given the option for the number of minutes, hours & days and nothing for specific date.

[Alan Kirk]

Is there anyway to schedule chore on specific date especially for like data load or ODBC output? If you are required to upload or load data at a specific date. Currently, your only given the option for the number of minutes, hours & days and nothing for specific date.

It's the same sort of situation as was discussed in this recent thread. There's nothing to do it directly, so you need to improvise. The easiest way is to simply set the chore to run every day and (say it was supposed to run on the 10th) put this code in the prolog of the first process:

Code: Select all

If ( DAY ( TODAY )  <> 10 );

   ChoreQuit;

EndIf;

If you want to you can mess about with external applications to trigger it, but since the code above takes almost no time to run it's probably the most straightforward way.

[appleglaze28]

Thanks Alan...I try to think of how to incorporate that since I'm thinking how it is done like for end of the month...since we have different end of month date either 30 or 31...maybe there was an easier way to define this.

[Alan Kirk]

Thanks Alan...I try to think of how to incorporate that since I'm thinking how it is done like for end of the month...since we have different end of month date either 30 or 31...maybe there was an easier way to define this.

If that's the case you may want to look at using either an attribute on a dates dimension, or some form of dates lookup cube. (The former was discussed in the other thread, though I prefer a cube solution since I find it more flexible.)

Rather than using the Day function you could check the attribute for the current date, or do a lookup in the cube (as the case may be) to determine whether the current date is an end of month.

Same basic principle, just a different test condition.

[Michel Zijlema]

Thanks Alan...I try to think of how to incorporate that since I'm thinking how it is done like for end of the month...since we have different end of month date either 30 or 31...maybe there was an easier way to define this.

To calculate the last day of the month you could take the first day of the next month minus 1.

Michel

[appleglaze28]

How can make my TI dynamic base on the look up cube since on my look up cube I defined the dimensions for Month & Year.

I assume I would require my Month dimension to need a month number alias to accomodate my needs? How do you reference lookup cubes in TI?

Can anyone help me out with this?