Owner-Targeted Email Notifications

The Geodatabase Manager (GDBM) email action handlers can send targeted email notices directly to the current owner of the design, session, or SDE version being processed. This is in addition to the global list of recipients specified in the Recipient parameter for the action handler.

To enable this behavior, type a new parameter for each potential owner of a design or session or SDE version, into the action handler parameter list. The Name field of each new parameter should consist of the character "@" followed by a user name. The Value should be the email address (or a comma-delimited list of email addresses) for that user.

When processing a design, session, or version, GDBM calls upon the Send Notification Email action handler or the Email Reconcile/Post Error action handler to obtain the current owner of the design, session, or version and try to match that user name with one of the user names listed in the Name field in the parameter list. If a match is found, the corresponding email address in the Value field of the matching parameter will be appended to the email address(es) specified in the Recipient parameter for the action handler. The current owner then receives an email as the current owner of the design, session, or version currently being processed.

For a design, the current owner is established by the CURRENT_OWNER_ID field of the row in the MM_WMS_DESIGNS table that corresponds to the design. For a session, the current owner is established by the CURRENT_OWNER field of the row in the MM_SESSION table that corresponds to the session. For a plain SDE version (not a design or a session), the current owner is established by the OWNER field of the row in the SDE_VERSIONS table that corresponds to the version.

The table below is an example parameter list showing how to set up the targeted emailing behavior for the Send Notification Email action handler in GDBM. The Recipient parameter is optional, so leave this Value blank if you want to send only targeted email notices (e.g., there are no recipients that always need to be notified regardless of which design, session, or version is being processed). If the Recipient parameter is left blank and no matching user name parameter can be found for the current owner of a particular design, session, or version, then no email will be sent at all in that instance.