SQL to count # of active jobs in a specific queue

Discussion created by MarkCavalieri608487 on Nov 10, 2016
Latest reply on Nov 11, 2016 by Michael_Pirson_282


I need to create a way to count the number of jobs active in a specific queue.  Limiting the max slots is not accomplishing what we are trying to do.  Does anybody have a piece of sql that can accomplish this ?

I don't have direct access to the AE DB to figure this out myself.