Business Alert Question

[35mph]

We need to set up a business alert that will notify us whenever the status of a PO changes to canceled.

It is apparent to me how we can have the alert run periodically to scan for that particular status code... but what we REALLY need is to be notified ONE TIME _when_ it changes... Not be notified everytime the alert runs of those that have that particular status.

It occurs to me that we could set the alert up to run (for example) every 5 minutes... and compare the "modified time" to the system time, etc... (except that in this table POP10100 there is not a modified time)... so I'm not sure how to be notified only when this column changes to a "6."

Triggers? I've looked VERY briefly into that, but that doesn't seem to include the notification features we would be looking for... but maybe I'm missing something on triggers..

This seems like such a common type of thing to want to do... is there a better approach?

 

[jazgeek]

definately a trigger on the POP10100 or 200 table if by line item fire off an email with the relevant data.

There's a nice thread in here someplace where I posted the trigger on the sop hold table that fires off an email every time a specific hold is removed. Should be much easier given the qualification's you're looking for.



-----------
and they wonder why they call it Great Pains!

jaz

 

[35mph]

jazgeek, thanks for the reply... after I posted this message, I created a trigger on POP10100 that updates another "audit" table, then I think we're going to use CDOSYS to send an email based upon activity in that table.

 

[stef315]

You can have the trigger send the email.