Email notification : workflows

Hi All, 

Also had few other related queries/doubts as below : 

1] How do we simulate stale workflows in OOTB AEM 5.6.1 instance. 

2] Also, in CRXDE lite we have TOOLS->QUERY option. From that probably we can retrieve the names of all the workflows in the system which are stale. 
Trying on this.Am I correct? 

Not sure if we can somehow make use of this, to meet the requirement[email notification to be sent when the number of stale workflows exceeds "x" in the system] we are targeting.

Hi Will,

Thanks a lot for your reply.

1] Reason I am after stale workflows 

   Many times we see cq performance is slow and the cause is stale workflows.Being from a support background and new to CQ,
   wanted to bring in some improvisation here, because if we are notified if such count is more than say 'x',
   we can proactively take some steps from our end.I also completely agree that we should find out the cause for 
   workflows going stale rather than going in for this, but for now this implementation would be very much helpful.

2] "Instead of writing your own code I would suggest using the workflow maintenance jmx bean"

   I did go through this(http://localhost:4502/system/console/jmx/com.adobe.granite.workflow:type=Maintenance) but not getting as to 
   how I can make use of this for my objective(i.e, notification to administrators when such count increases to more than 'x')

3] "If you want to simulate stale workflows the best way to do it"
    
   Trying to understand few things - workflow sling job queue,delete the jobs that workflow is expecting.

4] "As for periodically making this call, you can use the sling scheduler for this"

   Trying to understand this as it is not clear to me.

5]  From the first paragraph what I could understand was that internally sling jobs run workflows. Trying to get a better understanding here.

Some analysis done as below : 

In order to differentiate between aborted/running/stale and other categories of worflows 

1] In content explorer[http://localhost:4502/crx/explorer/browser/index.jsp] 

under /etc/workflow/instances/<respective date>/<respective model number> 

found a property by name "status" of type "String" whose value is "ABORTED". 

So, is it something like this property could be made use of to write code to differentiate stale workflows from others? 

"JCR observation", is this the one it refers to ? 

2] Another way is to use scheduling in Sling 

Can you please provide some additional inputs on this, as I do not have much idea and exploring things.

Hi All,

In order to get some more clarity on sling jobs & workflows.

went through "CONCURRENT WORKFLOW PROCESSING" and "CONFIGURE THE QUEUE FOR A SPECIFIC WORKFLOW MODEL"sections in https://dev.day.com/docs/en/cq/current/deploying/performance.html. 

Hi All,

Any thoughts/pointers/examples on doubt #2[mentioned in above posts] in specific and others , will be helpful.

Hi All,

Any thoughts/pointers/examples on doubt #2[mentioned in above posts] in specific and others , will be helpful.

look at example how to utilize workflow mbean at http://helpx.adobe.com/experience-manager/kb/workflow-monitor-via-jmx.html

Hi Sham,

Thanks a lot for your reply.

But I am not able to understand as to how I can make use of the mbean's available to meet my requirement[i.,e to send out a notification to system administrators when the number of stale workflows exceeds 'x']. I am not getting how should I go about implementing this. If you can provide detailed inputs/thoughts/pointers, it will be really helpful.