Jobs in the queue alerts

Question

Hello folks.

We had an instance a few times where our workflow jobs would start to get backed up to over 100 items stuck in the queue. Is there any type of alerting for this? I know we can log in and see the jobs and their status, but our users caught it before the admins did because we don't manually log in every day to look for this. We had some jobs that were stuck in the running status, and it caused a huge backlog.

Any ideas on how to get alerts on this?

raychase · Accepted Answer

I have a job that runs every 15 mins to pull relevant data from the MongoDB and store it in a SQL environment.  Then, I have a SSIS job that queries the SQL environment (particularly, the completed datetimes of recently completed workflows).  If the time between the max(completed datetime) and the time the SSIS job runs ever exceeds 30 minutes, then it emails our operations center and lets them know that the Alteryx Server is backed up and not completing jobs in timely fashion.

superjesse · Accepted Answer

Thank you. Sounds like a good solution.