Early warning mails - Intergraph Smart Materials - 10.2 - Administration & Configuration - Hexagon

You can receive alerts for any successful or unsuccessful integration between Smart Materials-Jovix workflows. To create an alert, use the Early Warnings screen in Smart Materials Web.

The following is an example of an alert code for failed events:

The following example code can be used to send an alert mail that includes details of all the failed integrations in the last 15 minutes:

SELECT entity_type, entity_name, comments

FROM mi_jvx_stagings

WHERE lmod BETWEEN SYSDATE - INTERVAL '15' MINUTE AND SYSDATE

AND status = 'FAILED'

When the alert is triggered, all the assigned users receive an email as specified in the Email Subject and Email Body fields of the Early Warnings screen.

The following table lists all the database columns that can be used to create early warning alert:

What do you want to do?

• Early warning definitions

  • Define early warning query

• Setup early warning

  • Assign users to alerts

  • Assign alerts to roles

• Early warning alerts