Notification for Scheduled Job Failure

[vcaracci75]

We have several scheduled jobs that run nightly to import user information from Workday. These jobs are all SFTP feeds. Is there a way to trigger a notification if one of these jobs does not complet successfully?

[Harshinya1]

You can try a validation check with a business rule on import set table by checking for error count >0, to fire an event, which would trigger a notification or an incident.

Hope this helps

[vcaracci75]

How would this work, via a script?

Thanks,

Vince

[Harshinya1]

1. Write an after business rule on transform history table

2. Add filters to run only for your desired transform maps

3. Add advanced condition current.errors>0

4. Create an event

5. Add below syntax in the advanced section script. 

gs.eventQueue('your event name',current,gs.getUserID(),gs.getUserName());

6. Create a notification to trigger when this event is fired.

Hope this helps