Automic Workload Automation

 View Only
  • 1.  Ability to monitor waits when configured to "allow 1 simultaneous execution"

    Posted 25 days ago

    Hi,

    I'm wondering if there is a way to monitor the instances of job executions that have to wait for a previous instance of the same job to finish.  We have some jobs configured to "allow 1 simultaneous execution," and the configured action is "wait".  I would like to measure the impact these waits have, but to do so I first need to be able to tell when they occur. 

    It seems like the ideal solution would be a db query, so I could report on these; but any other technique would help.

    Also, is it possible to tell when a SYNC object has forced a job to wait?



    ------------------------------
    Thanks,
    Doug
    ------------------------------


  • 2.  RE: Ability to monitor waits when configured to "allow 1 simultaneous execution"

    Broadcom Employee
    Posted 24 days ago

    Hi Doug,

    you should be able to query the EH_status field in the EH table for

    1697 Waiting for SYNC
    1709 Waiting for end of parallel task

    Regards, Markus




  • 3.  RE: Ability to monitor waits when configured to "allow 1 simultaneous execution"

    Posted 24 days ago

    Hi Doug,

    Markus has already answered the "what". The "how" should be a DB query. Everything triggered in the system (regardless if from within our from the outsdie) would create too much traffic and system load.

    So the best way might be putting selected records from EH into some sort of data mart. This stresses the system less and allows also the building of a history.

    Regards,
    Jürgen



    ------------------------------
    Juergen Lechner
    Managing Consultant
    setis GmbH
    Germany
    ------------------------------