TM1 Forum

Is there anyway to run a chore on a given day of the month. E.g. always on the 20th?

I guess I could work around it by running the process nightly and getting it to quit if it's not the 20th, but I'd rather just kick it off once a month.

Martin

I have the same problem and the only way I can see to do it is to test if it's the Xth of the month and then kick off the chore proper or not as the case maybe, just like you say. It's probably possible using a batch file and the api but I can't see that it is worth the drama.
Cheers,

There is another way. If you have installation of MS SQL you could use that to schedule the TI chore. There is a script in the code section (Of this forum) that lets you run a process / chore from the command prompt. Simply embed this script (edit as needed) within a DTS and schedule. If you would like to know more about this option let me know,

Jim.

That'd be great... except we don't have SQL. We're bashing heads to get it as we need to get something robust for maintaining dimensions and security between servers.

Might just have to do the daily run as mentioned by Steve.

Martin

Why not set Windows scheduled tasks of your server to run the TM1ChoreExecute.exe available in the tools section of the forum?

Only works if you have admin rights on your PC tho, so it depends on the situation

There is another way to go about this. We have a binary cube (year, month, day) and it is populated with the days of the month that are work days. We can then schedule chores to run on a given work day of the month or on a calander day. This block of code is inserted on the prolog tab and its bullet proof.

Wes

#* Lock outlooks on the 7th workday

ThisYear = SubsetGetElementName('Year', 'ThisYear', 1);
ThisMonth =SubsetGetElementName('Time', 'ThisMonth', 1);
ThisWorkday= cellgetn('workday', ThisYear, ThisMonth, 'WorkDaysToDate');

if(ThisWorkDay <>7);
ChoreQuit;
endif;