thanks for your replies! Utkarsh, maybe you can tell me some more details about your solution: - When you say 'trigger', you don't mean a normal Oracle trigger? - How did you initiate this summary notification? By PPM means?
Here we do not have access to Oracle SMTP package, so we notify by java client.
We have created a custom table which is similar to Program_content table (also have additional columns about content details) ; daily the nighlty job perform these steps:
For first time, load the custom table from the program content table (only for active programs)
Second day onward
Check the diference in program content table and custom table (for acive programs only)
based on difference trigger the notification for Program manager
Once notifcations are triggered then agian SYNC the custom table with program content table
This will keep update the program managers; similar approach you can have for audit trail... keep inserting the changes in custom table or probablly you can have trigger on Program content table to insert the changes in custom table.
Cheers.. Utkarsh Mishra
-- Remember to give Kudos to answers! (click the KUDOS star)