09/25/2022 10:23 AM
Hi Team,
In the article Managing email template, I found out a template for the notification to be sent when any job fails. Can you please help me by letting me know how to trigger that email.
09/25/2022 01:13 PM
If you are looking for an immediate notification on an import job failure, you can attach the failure notification to the connector & it will trigger the notification.
Make sure you create the failure notification email template before attaching it to the connector.
If you are looking in general for a report of all failed jobs, you could create an analytics report to gather the details.
select e.jobid, e.jobname,e.jobstartdate,e.jobenddate,i.logdataasxml,e.SAVRESPONSE
from ecmimportjob e,importlog i
where SAVRESPONSE != 'Success'
and e.jobid=i.jobid
-Siva
09/26/2022 06:36 AM
Hi Siva,
Will you please provide me the attribute which will fetch the jobname for the scheduler which is configured in the SSM. the attribute "e.jobname" is not populating the exact name.
09/26/2022 06:58 AM
select e.jobid, e.jobname,e.TRIGGERNAME,e.jobstartdate,e.jobenddate,i.logdataasxml,e.SAVRESPONSE
from ecmimportjob e,importlog i
where SAVRESPONSE != 'Success'
and e.jobid=i.jobid