We have a number of report jobs (15) that run via triggers set off by external sources as the data processing is complete for those jobs. We have set up events to run when the jobs are complete to send a "completed" email. We want to set up a single email to go out when *all* the jobs are complete. Unfortunately we don't know which one finishes last, nor will it necessarily be the same one every day as different reports contain different amounts of data depending on the day. I need someway to "wrap" all the jobs finishing into one event/job so that we know when all the jobs are done without getting flooded with emails. We do know all the jobs that will run each day, just not their timing.
Any ideas?
Thanks in advance,
Lisa
you could make use of Audit Data base and Event Studio
Please refer to this link
http://www.cognoise.com/community/index.php?topic=4737.msg16635#msg16635