This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Event handler for drivers

Question
0

Sign in to vote
Hi,

Recently i had following requirement:-

Whenever a driver is created, updated and deleted i need to do some action. That is whenever a driver is ceated a need a handler (add handler event) where i can write the code to perform the action. Similarly i need to trap update and delete events.
I looked into server event handler provided by project server but didn't found any even handler for derivers.
As a work around i was thinking to create trigger on Driver table present in Published database of PWA. But i think it is not recomended to temper the Draft, Published and Archive db (except reporting).

Please help me if you know how to trap the add, update and delete event for driver.

Regards,

Deepak
Deepak Kejriwal
Thursday, November 24, 2011 10:00 AM

Answers

0

Sign in to vote
Hi Deepak,If y

Your requirement is a tough one, as you have noted, there is no event handler for the drivers and touching the Published DB is a definate no no. Perhaps you could look at doing something clever with the reporting db, perhaps via trigger or view. By default the Portfolio stuff won't come over to the reporting db, but the Portfolio Strategy Object Publish to RDB solution starter (http://archive.msdn.microsoft.com/P2010SolutionStarter) will push the relevant items over into the Reporting DB.

Hope this helps,

Alex Burton
www.epmsource.com | Twitter
Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
- Proposed as answer by Christophe FiessingerMicrosoft employee Monday, November 28, 2011 9:28 PM
- Marked as answer by Christophe FiessingerMicrosoft employee Thursday, December 22, 2011 5:34 AM
Saturday, November 26, 2011 5:43 AM