Send a analytics report when job was failed.

[Sekhar]

Hi,

I need to send analytics report automatically when job was failed. 

Job type= Provisioning job & account import job.

Could you please help me in this scenario.

Thanks,

Sekhar

[dgandhi]

I dont think analytics report can be sent at run time when job fails. Instead try mapping email template to the corresponding connections.

Another option is to create one analytics and scheduled to run every 4 hours with query like below

You can modify the query with your critical trigger names.

[Sekhar]

Hi @dgandhi ,

Now case was changed. 

1. we have to send an email notification when job was failed. In the mail, we have to inform which job is failed on time & date.

2. Send an failed job report daily for last 7 days failed details.

Thanks,

Sekhar.

[dgandhi]

You Can use above report for Failed Job Analytics Report

[rushikeshvartak]

select Triggername as 'Job Name',savresponse as 'Job Status',jobenddate,jobname from ecmimportjob where ((JOBENDDATE is null) or SAVRESPONSE not like 'Success') and JOBSTARTDATE > date_sub(now(),INTERVAL 7 DAY) group by jobname,triggername;

[rushikeshvartak]

select * from ( SELECT e.endpointname AS Endpoint, e.endpointKey AS endpointKey, COUNT(a.taskkey) AS Total_Tasks, SUM(CASE WHEN a.status = 1 THEN 1 ELSE 0 END) AS Pending, SUM(CASE WHEN a.status = 4 THEN 1 ELSE 0 END) AS Discontinued, SUM(CASE WHEN a.status IN (3 , 9) THEN 1 ELSE 0 END) AS Success, SUM(CASE WHEN a.status IN (7 , 8 ) THEN 1 ELSE 0 END) AS Error, SUM(CASE WHEN a.status IN (3 , 9) THEN 1 ELSE 0 END) * 100 / COUNT(taskkey) AS Success_Percentage, SUM(CASE WHEN a.status IN (7 , 8 ) THEN 1 ELSE 0 END) * 100 / COUNT(taskkey) AS Failure_Percentage, CASE WHEN ec.STATUS = 1 THEN 'Connection Successful' ELSE 'Connection Failure' END AS 'Connection_Checks' FROM arstasks a, endpoints e, securitysystems ss, externalconnection ec WHERE DATE(a.taskdate) = CURDATE() AND a.endpoint = e.endpointKey AND e.SECURITYSYSTEMKEY = ss.SYSTEMKEY AND ss.EXTERNALCONNECTION = ec.EXTERNALCONNECTIONKEY GROUP BY a.endpoint ORDER BY Failure_Percentage DESC) as ABC where ABC.Failure_Percentage > ABC.Success_Percentage;