Which table stores notification emails for a particular job in CA DSeries WA?

[Balunkeswar Sahu]

Which table stores notification emails for a particular job in CA DSeries WA?

[Nitin Pande]

Hi,

The alerts, email are kept with job.  The data is kept in XML blob format.

HTH,

Nitin Pande

------------------------------
Support
Broadcom
Toronto
------------------------------

[Balunkeswar Sahu]

How to read this data? and what is the table name? I need to know all the email list for all the jobs.

[Nitin Pande]

Is there a reason you want to read the data?

You cannot read the XML data easily via **** SQL.  The data is parsed thru our code and scheduler then figures out what to do.  

HTH,

------------------------------
Support
Broadcom
Toronto
------------------------------

[Balunkeswar Sahu]

Yes, we need to get the report for all the jobs having one particular email id, as we need to update a particular email id for all the 200 jobs. We do not know how many jobs have the same email id in the notification settings. So, if we can pull the report, we can easily identify the number of jobs.

Do let me know how to do this?

Thanks

Balu

[SHARON SHIMANEK]

Hi,

I know you prefer to get a list of jobs but this would at least get you the list of applications with that email id.  Just update between the %'s.  The below will find any string within the application or job defined within an application but the results will only show application name. This is my go to for anything the job find doesn't search.  Once you have the applications depending how big or small they are you can look at each job or simulate and choose all jobs then do a find from there. you need the % around the string of info you are looking.

select * from  WA.esp_ams_DF where WA.esp_ams_DF.definition like '[e-mail]%'

Hope this helps.

Sharon