22 Mar Daily or Weekly statistics on what has been processed in webMethods
Query to enter in the Dynamic Adapter.
Now once this is done a service can be created to enter a number of days (e.g.: 1 for daily reports, 7 for a week). You can take the current day and set is as the toTime input parameter of the query and for the fromTime you can subtract the number of days from today’s date.
Format of those parameters should be “yyyy-MM-dd 00:00:00”. E.g. for daily statistics: now = 2012-03-08 13:48:35 toTime will be 2012-03-08 00:00:00 fromTime will be 2012-03-07 00:00:00 Which will generate the statistics results for everything processed yesterday Once this is done and you can execute the adapters we created above and with that result you can generate the html(after conversion to XML)and send it out via mail if you want.
This has been tested on webMethods v8.
Author: Jeroen W.