TM1 Forum

Hi All,

I have a Chore that runs several processes that populate dimensions and cubes.

At the end of this chore I would like to run a process that sends an email to a user to confirm either that the chore completed ok or it failed. I've worked out how to send an email - but how do I identify when all the processes in the chore have run ok to be able to decide which email to send? Is there a standard/typical way to handle this?

Thanks

Andy

I would do the check within each process and write when errors to a file. Then the last process in the chore completes a check for the file, sends an email if it exists. You could even write the name of the process and type of error to teh file and attach it to the email. Check out the reference guide. It contains everything you'll need (command wise) for this.

ATD wrote:Hi All,

I have a Chore that runs several processes that populate dimensions and cubes.

At the end of this chore I would like to run a process that sends an email to a user to confirm either that the chore completed ok or it failed. I've worked out how to send an email - but how do I identify when all the processes in the chore have run ok to be able to decide which email to send? Is there a standard/typical way to handle this?

Thanks

Andy

Hi ATD,This might help.Thanks
http://www.tm1forum.com/viewtopic.php?f=3&t=1785

Why use a chore? You can parse a delimited string of processes in a sub process that runs each process and checks the success status. From the master calling process you can check the status of the sub process. If the sub process is successful it means all of your processes in the delimited string ran successfully and you can send the email.

If that is too complicated just put your process executes in a master TI and check the status of each one. If any fail you can exit otherwise send success e mail. All of our automated processes work in this kind of of fashion. To tell you the truth, we have basically abandoned using chores as they are more limiting in most cases. Unless you don't want to use tm1runti.exe or you need the scheduling ability inside tm1.

You got some good edvice.
I will prefer to use a Global Variable which will be update during the chore if one of the process has failed.

Good look

Many thanks for all your responses, I'll go through them and try them all out to see what works for us

Thanks

Andy