Automic Workload Automation

  • 1.  SQL to count # of active jobs in a specific queue

    Posted Nov 10, 2016 12:04 PM

    Hi,

    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.

    Thanks



  • 2.  SQL to count # of active jobs in a specific queue

    Posted Nov 10, 2016 12:14 PM
    This selects both workflows and jobs for a queue, but you could add more logic to ignore the objects you need to ignore.

    select * from eh where EH_Queue = 'CLIENT_QUEUE'


  • 3.  SQL to count # of active jobs in a specific queue

    Posted Nov 10, 2016 03:04 PM
    This query also selects objects that have not yet started.  You can filter those out with this;

    where not eh_starttime is null


  • 4.  SQL to count # of active jobs in a specific queue

    Posted Nov 10, 2016 07:11 PM
    Building off of what Pete said I would also filter by EH_Client as CLIENT_QUEUE exists in every client that exists.