Schema user job (File based users import) failure notification

[Community_User]

Originally posted on April 15 2021 at 09:49 UTC

Hi,

How can we enable job failure notifications for file based users import

In case if we have connection, we can set it up at email template level

But how to achieve for file based user import

Thanks

[Community_User]

Originally posted on December 1 2021 at 10:12 UTC

any resolution provided for this scenerios

[Community_User · Accepted solution]

Originally posted on December 1 2021 at 18:37 UTC

Hello,

As we do not have connection defined for schema based import, Other Alternate Solution we can try is to have a analytics report around job status table (ecmimportjobs) with jobname filtered for the scehma family.

Build a report and schedule to send out email notification on daily basis for respective team to take action.  A sample query for reference is provided below.

SELECT date(JOBSTARTDATE) as "Job Date", externalconnection as Application, CASE WHEN SAVRESPONSE = 'Success' THEN "Success" ELSE "Error" END AS 'Job Status', count(*) as "Job Execution Count" FROM ecmimportjob where jobname in ('SchemaAccountJob','SchemaUserJob') group by date(JOBSTARTDATE),externalconnection,'Job Status';

Regards,

Sagar Srikantaiah

Product & Partner Success