Hello Ron, Here is what I am trying to accomplish: I have a table with few million records which gets updated in real time. I have to monitor value of one column and if I find a record with that value, I need to report it or write it to a table with create date and derive a real time dashboard. What I have Done so far: I set up fields, tasks and business rule using SAS Data Management Studio. I have set up data job which read from table and uses monito node which in result triggers a event which essentially write that record to a table. My SQL currently checks for any new records that were added in the last five minutes, so reporting is always on new records added in last five minutes. Question: For real time monitoring, do I need to run this job every five minute or is there a way to inject this at database level? Regarding dashboard that I talked about, do you recommend on using DM Studio for this or I should look for some other tool? Any inputs/help here is greatly appreciated. Best regards, Chetan
... View more