Page 1 of 1
Scheduling chores at a specific date
Posted: Mon Nov 09, 2009 1:20 am
by 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.
Re: Scheduling chores at a specific date
Posted: Mon Nov 09, 2009 2:11 am
by Alan Kirk
appleglaze28 wrote: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.
Re: Scheduling chores at a specific date
Posted: Mon Nov 09, 2009 5:49 am
by 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.
Re: Scheduling chores at a specific date
Posted: Mon Nov 09, 2009 5:53 am
by Alan Kirk
appleglaze28 wrote: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.
Re: Scheduling chores at a specific date
Posted: Mon Nov 09, 2009 6:23 am
by Michel Zijlema
appleglaze28 wrote: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
Re: Scheduling chores at a specific date
Posted: Wed Nov 11, 2009 6:23 am
by 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?