search cancel

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

book

Article ID: 255758

calendar_today

Updated On:

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)