To see chore scheduled timing

Post Reply
Rams
Posts: 21
Joined: Thu Mar 14, 2013 12:29 am
OLAP Product: TM1_Cognos
Version: 9.5.2_10.1_10.2
Excel Version: 2007
Location: Sydney, Australia

To see chore scheduled timing

Post by Rams »

Hi TM1 Geeks,

This must be a silly question to ask :( , but I'm looking for the best way to see the chore scheduled timing other than the below methods. I heard TM 1 web will do but we are not using at all.

1. First strike, deactivate the chore and see the scheduled timing - which is registered in a log file <don’t want to leave a footprint>
2. Secondly, I can just a click on the chore, shows the process involved in property window and then double click on the process will do, but this will not work if there are more than one process involved in a particular chore as a sequence.

Any inputs are welcome,
Ram
failurehappening
Posts: 78
Joined: Tue Nov 30, 2010 1:18 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: To see chore scheduled timing

Post by failurehappening »

If you have access to the file system you can look at the .cho object in notepad. It will look like this:

Code: Select all

534,10
535,Daily Backup 9pm
530,20130118130102
531,001000000
532,1
13,16
6,"Sys.Serv.Backup"
560,0
533,1
1405,0
The 3rd line down, after the comma, indicates the date and time (in GMT) that is configured in the chore window. Here we have 530,20130118130102 which shows the backup was scheduled to run from the 18th January 2013 at 13:01.02 GMT, which is 9PM in Perth.

The 4th line down, after the comma, indicates the frequency. Here we have 531,001000000 which shows it is set to run every day. The break up for that is the first 3 digits is days, then 2 hours, 2 minutes, 2 seconds.
RHR
Rams
Posts: 21
Joined: Thu Mar 14, 2013 12:29 am
OLAP Product: TM1_Cognos
Version: 9.5.2_10.1_10.2
Excel Version: 2007
Location: Sydney, Australia

Re: To see chore scheduled timing

Post by Rams »

That's Kewl stuff to note....thanks & its very helpful by the way what if the people who are using the client tool alone (perspective)...just curious to know ;)

I hope the best practice is to give the "CHORE_NAME (Weekly/Daily <day> <time> <am/pm>)"
Rams
Posts: 21
Joined: Thu Mar 14, 2013 12:29 am
OLAP Product: TM1_Cognos
Version: 9.5.2_10.1_10.2
Excel Version: 2007
Location: Sydney, Australia

Re: To see chore scheduled timing

Post by Rams »

to add up, I was wondering how could we know whether its active or inactive by just looking into .cho file, Finally found
533, 1- Active & 0 - Inactive chore.

Thanks "failurehappening"
Gareth Soo
Posts: 14
Joined: Fri Nov 23, 2012 3:25 am
OLAP Product: TM1
Version: 9.52
Excel Version: 07

Re: To see chore scheduled timing

Post by Gareth Soo »

Hi Ram, give my chore scheduler a go. I have already mapped it to read the server chore files and display them in a spreadsheet:

http://www.tm1forum.com/viewtopic.php?f=21&t=8587
Rams
Posts: 21
Joined: Thu Mar 14, 2013 12:29 am
OLAP Product: TM1_Cognos
Version: 9.5.2_10.1_10.2
Excel Version: 2007
Location: Sydney, Australia

Re: To see chore scheduled timing

Post by Rams »

Hi Gareth - Thanks for the spreadsheet!!!

I'm getting an error while the macro trying to open the RUX files. I've connected as client machine, so path should be something like below, I guess its not the problem with path.

\\servername\d$\sharefolder\tm1servername\Data

"Set TextStream = FSO.OpenTextFile(directory & f1.Name, 1, False, -2)"
Gareth Soo
Posts: 14
Joined: Fri Nov 23, 2012 3:25 am
OLAP Product: TM1
Version: 9.52
Excel Version: 07

Re: To see chore scheduled timing

Post by Gareth Soo »

Try adding a \ to the end of the path
Rams
Posts: 21
Joined: Thu Mar 14, 2013 12:29 am
OLAP Product: TM1_Cognos
Version: 9.5.2_10.1_10.2
Excel Version: 2007
Location: Sydney, Australia

Re: To see chore scheduled timing

Post by Rams »

Kudos!!!, it works and very handy one for quick analysis.... Thanks Gareth!!!
Post Reply