email post editing

Question

Dear all,
I would like send an email (for example at an administrator) whenever an user modify a layer/table. The layers/table are within a version of enterprice geodatabase on ArcSDE10-Postgresql.
Is there this opportunity?

Thank in advanced.
Giuseppe P.

VinceAngelo · Answer

I have never given that sort of solution any consideration, so I cannot begin to suggest how to solve it.

I expect you'll find it challenging to associate events with rows outside a relational database context.

Good luck.

- V

ChandreyeeLahiri · Answer

Vince:

I'm asking the same question only I want to be emailed/notified only when a point is added to a hosted feature service. The addition of a point marks the start of a workflow in my project and I want to be notified so that I can launch a particular workflow.I'm not talking of a versioned database...just a simple hosted File Geodatabase.

Can you clarify HOW to set up email notification without the postgresq solution outlined below?

JoeBorgione · Answer

Like Vince, I'm a systems administrator and I get enough mail selling me hoses, pharmacuteculs, and low interest rate re-financing loans, not to mention those emails looking for money to help get diamonds out of some third world country....

My suggestion is to create a trigger that gets pulled upon an edit.  This trigger updates a date field.  Then instead of an email, the admin guy just queries the data for a particular edit_date.  See this thread...