Where are email values set in notifications stored in the database?

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Where are email values set in notifications stored in the database?

Environment

Release : 8.x, 9.x

Component : CA Automic Applications Manager (AM)

Resolution

Below is the Table and column information for notifications, email values, as well as Job/Process Flow and component. Job/Process Flow and Component table will hold information on which notification is assigned to Job/Process Flow or Component, if assigned.

• Notification objects are stored in the table AW_NOTIF
  • AW_NOTIF_SEQ - primary key
  • AW_NOTIF_NAME - name of Notification object
• The details or rules of the notifications are stored in the table AW_NOTIF_DETAIL
  • AW_NOTIF_SEQ - primary key to AW_NOTIF table
  • AW_NOTIF_EMAIL - email recipient value
• A Job object is stored in table SO_JOB_TABLE, which will detail if the Job has a notification assigned to it
  • SO_MODULE - Name of Job
  • SO_JOB_SEQ - Primary key
  • SO_NOTIF_SEQ - Primary key to AW_NOTIF (null value means Job/Process Flow does not have notification set)
• Components of a Process Flow are stored in table SO_CHAIN_DETAILSO_TASK_NAME - Component alias name
  • SO_CHAIN_SEQ - primary key to SO_JOB_TABLE (component's Process Flow)
  • SO_JOB_SEQ - primary key to SO_JOB_TABLE (component's core Job)
  • SO_DET_SEQ - primary key
  • SO_NOTIF_SEQ - primary key to AW_NOTIF (null value means Component does not have notification set)