Automated alert scheduling of AEM inbox workflow failures

[somasreeb804333]

I wanted to schedule alert emails of particular workflow item failures, or items stuck for longer than a specific period in Inbox.

However for doing this, I wanted to gather the json stats for inbox with suitable params (eg- https://dpe.pwc.com/libs/cq/workflow/content/inbox/list.json?start=0&limit=1&filter-model=%2Fetc%2Fw... ) and feed that through json parser and email in specific format using java mail api.

Could you please advise me if there would be any other easier way of doing this, as particularly both the json parsing (extracting fields like- "startTime", "items","description", "title") and mailing configuration isn't quite giving me the expected results.

Please guide me through this, if particularly implemented by anyone at present (without using custom workflow or AEM email services)

[smacdonald2008]

I do not think that you can perform such an advanced use case without using API and Java code.

For this use case - have you looked at using Workflow MBEAN functionality -- Creating Adobe Experience Manager 6.4 Sling Servlets that invoke MBean operations

You can view available MBEAN functionality here - http://localhost:4502/system/console/jmx/com.adobe.granite.workflow%3Atype%3DMaintenance.

Another option that does also involve code is to look at use of Workflow API. Using this API, you can get workflow information, such as shown here - Adobe Experience Manager Help | Retrieving AEM Workflow information using the Workflow API

[arunpatidar · Accepted solution]

Hi,

You can setup notification on abort/failure from osgi config Day CQ Workflow Email Notification Service.

Configuring Email Notification

or you can listen to below event and send mail using Java Mail API