Author |
Message
|
bprasana |
Posted: Wed Oct 06, 2010 9:21 am Post subject: Nightly Messages |
|
|
 Disciple
Joined: 18 Apr 2005 Posts: 179
|
Hi,
Scenario:
A WMB flow(s) should send one email at the end of the day(everyday) at midnight.
Email body should contain the list of records(or one unique field from each record) which failed during the day.
Problem:
We are facing some challenges while implementing this using collector node. We are not able to set absolute time of midnight. As it depends mostly on when the first trigger message arrives at input.(which varies in this case)
We are trying to solve this problem without the use of crontabs or any external resources.
Is it possible? If not,Can anyone suggest any other design approaches?
Regards,
bprasana |
|
Back to top |
|
 |
Vitor |
Posted: Wed Oct 06, 2010 9:31 am Post subject: Re: Nightly Messages |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
bprasana wrote: |
We are trying to solve this problem without the use of crontabs or any external resources. |
Why? On the face of it sounds like an ideal job for a scheduler. _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
mqjeff |
Posted: Wed Oct 06, 2010 9:50 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
I wouldn't use collector for this. That's not what it's designed for, not really.
I would, however, use Timeout nodes.
Unless the requirement for midnight is absolutely absolute, in which case I'd trigger the flow from a job scheduler. |
|
Back to top |
|
 |
bprasana |
Posted: Wed Oct 06, 2010 11:08 am Post subject: Great |
|
|
 Disciple
Joined: 18 Apr 2005 Posts: 179
|
Sounds like a its not possible then.
We need a external trigger for this.
Thanks
bprasana |
|
Back to top |
|
 |
lancelotlinc |
Posted: Thu Oct 07, 2010 9:23 am Post subject: Re: Great |
|
|
 Jedi Knight
Joined: 22 Mar 2010 Posts: 4941 Location: Bloomington, IL USA
|
bprasana wrote: |
Sounds like a its not possible then.
We need a external trigger for this.
Thanks
bprasana |
Yes, it is indeed possible. The problem here is not lack of technology, it is lack of imagination.
1. Everytime you get a failed message, have your error message handler write an entry in a log4j file.
2. Schedule a cron job to mail the file each day at the time you choose.
Sounds simple!
Think of all the possibilities. Don't constrain your thinking to just the high speed messaging engine. Your high speed messaging engine runs on a high performance Unix server, with all the rights and priviledges thereto. Including Java, log4j, and cron. _________________ http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
Back to top |
|
 |
mqjeff |
Posted: Thu Oct 07, 2010 9:34 am Post subject: Re: Great |
|
|
Grand Master
Joined: 25 Jun 2008 Posts: 17447
|
lancelotlinc wrote: |
1. Everytime you get a failed message, have your error message handler write an entry in a log4j file. |
Have you considered acquiring a screwdriver to go with your hammer? |
|
Back to top |
|
 |
lancelotlinc |
Posted: Thu Oct 07, 2010 9:39 am Post subject: |
|
|
 Jedi Knight
Joined: 22 Mar 2010 Posts: 4941 Location: Bloomington, IL USA
|
That would make changing the oil too easy. I'd rather strip the threads.
Unless you are speaking of the alcoholic variety. _________________ http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
Back to top |
|
 |
Vitor |
Posted: Thu Oct 07, 2010 9:55 am Post subject: |
|
|
 Grand High Poobah
Joined: 11 Nov 2005 Posts: 26093 Location: Texas, USA
|
lancelotlinc wrote: |
That would make changing the oil too easy. I'd rather strip the threads.
Unless you are speaking of the alcoholic variety. |
This all seems to be going a bit off topic.
We have a section for humour & light hearted comments; don't let it leak into the more technical areas. Likewise, tongue-in-cheek suggestions should be appropriately labeled to prevent less experienced readers taking them seriously. _________________ Honesty is the best policy.
Insanity is the best defence. |
|
Back to top |
|
 |
Bharat_123 |
Posted: Thu Oct 07, 2010 12:55 pm Post subject: |
|
|
Acolyte
Joined: 15 Sep 2008 Posts: 58
|
Right now we use some kind of same process..but we use TX node in a WMB flow. IN the map we decide at what intervels we need to send an emails. FYI..we use job scheduler..its very easy and straight forward...
no hassle..its been in prod since may 2010...
May be this will help u |
|
Back to top |
|
 |
ajit1981 |
Posted: Thu Oct 07, 2010 10:49 pm Post subject: |
|
|
Apprentice
Joined: 09 Apr 2010 Posts: 41 Location: Bangalore, Inida
|
Hi, We also had same kind of requiremnt previosuly. on that time we have done like this.
We had used the TimeoutNotification and Timeout Control node on that time,Since timer node will trigger once when the flow will restart or at schedule interval time, For schedule interval its ok it will invoke the flow after 24 hours it will check and send the mail . but between this if flow is restarted due to any reason like broker restarted,Excution group restarted,etc for this condition we were cheking if the time of timer message match with the schedule time(i.e time when it has to send the mail) then send the mail or if its not match then dont send the mail. |
|
Back to top |
|
 |
|