Schedule Time at Chores

[winsonlee]

Is there a way to find out what is the schedule time for all the chores without actually going into individual chores to see the schedule time ?

When I click on the "Chores" it only gives me Name, Security Owner, Replication Server, Memory Used, Private and Active. Will be handy if they are able to see "Schedule Time" on the summary page as well.

[rkaif]

Yes there is a way.

Chores are saved a *.CHO files. If you open the *.CHO file in a Text Editor. Line 2 of this file will give you the GMT Date/Time. Line 3 will tell you information about the Frequency of the chore.

Once you can get this information you can write a routine and display this info in a Report or even you can create a Cube to show this information.

HTH.

[winsonlee]

You are right.. I can read each of the *.CHO file and populate line two and three data into a cube

thanks for the tips ....

[Alan Kirk]

You are right.. I can read each of the *.CHO file and populate line two and three data into a cube

thanks for the tips ....

Then all you need to do to make the information useful is:
(a) Convert the starting time into a datetime value;
(b) Convert the increment to a datetime value;
(c) Increase the starting time by that increment until you get past the current time;
(d) Oh, and since the starting time is stored in UTC not local time, determine your UTC offset to change the current time from UTC to your local time to determine when the next execution will be.

You could do most of those things by rules (except for the UTC offset), but of course if the scheduling of a chore is changed your cube will never know about it unless you run the process that populates it again by re-reading all of the .cho files.

(Personally I use an application that I wrote using the API which is always real time... but the API is the API, and not to everyone's taste.)

I think that CubeWise's Vizier has a screen that shows the list as well.