How to send a email notification when the scheduled job will be failed

[Sagaya1]

Hi ,

I have a scheduled data import which will pull the data from external DB and push it into servicenow table.

Now i need to send a email notification if the job will fail. So please help share the steps / sample code .

1. Do  we need to write a script in "execute post -import script" in scheduled data import? if yes please share the sample code.

2. OR need to write a script in "transform script - on complete" in transform map? if yes please share the sample code.

3. How to send a email notification if job fail? please share the sample code & steps.

Regards

Sagaya.

[SanjivMeher]

So basically you want to send a notification when an import fails?

You can create a notification on the Import Set Run table, with Condition State = Completed with Errors 

[Kieran Anson · Accepted solution]

You've got a couple options which are covered in the below post, but it rather depends if your notification is just a "hey, this broke" or if you want to include details. Also depends if you want a single email for the overall report or email notification per line.

https://community.servicenow.com/community?id=community_question&sys_id=77fa4baddb5cdbc01dcaf3231f961939