Automic Workload Automation

Expand all | Collapse all

SQL query for showing monitor of a Scheduler

Jump to Best Answer
  • 1.  SQL query for showing monitor of a Scheduler

    Posted 06-08-2015 08:50 AM
    Hi,

    I have some scripts for the Automic Automation Engine to display some information to our wiki or to Icinga. For example, showing the entries of a scheduler, Information about Jobs in the short term scheduler, Jobs with ended not ok, Workflows with inactive Steps, Workflows with conditions an so on. All these things are solved with an sql-query against the database. 

    Now I would like to have a sql query which displays the monitor of an scheduler. Sometimes a workflow name changed (and somebody didn't change this in the schedule object) oder a calendar name didn't exist. 

    Has anybody an idea to solve this? 

    Best wishes
    Jessica


  • 2.  SQL query for showing monitor of a Scheduler

    Posted 06-08-2015 01:29 PM
    Are you looking for info about the tasks in a schedule for the current day or past executions?


  • 3.  SQL query for showing monitor of a Scheduler

    Posted 06-09-2015 12:32 AM
    Hi,

    it should be the past executions since the periodical change (every day 0.00 in our system) of the scheduler. 

    Best wishes 
    Jessica


  • 4.  SQL query for showing monitor of a Scheduler
    Best Answer

    Posted 06-09-2015 11:20 AM
    If you know the RunID of the schedule in question, you could do something like this. 

    SELECT AH.AH_LDate, AJPP.AJPP_Object, AJPP.AJPP_JobStatus
    FROM AJPP AS AJPP
    INNER JOIN AH AS AH ON AH.AH_Idnr = AJPP.AJPP_AH_Idnr
    WHERE AJPP.AJPP_AH_Idnr = <RunID>

    This will give you the date of the schedule, object name in the schedule, and the status of that object. 

    if you need it by date, you can do something like this. 

    SELECT AH.AH_LDate, AJPP.AJPP_Object, AJPP.AJPP_JobStatus
    FROM AJPP AS AJPP
    INNER JOIN AH AS AH ON AH.AH_Idnr = AJPP.AJPP_AH_Idnr
    WHERE AH.AH_LDate = '2015-06-08 05:00:00.000'

    You would have to change the date you want and the time depending on your time zone. 

    Hopefully that helps! 


  • 5.  SQL query for showing monitor of a Scheduler

    Posted 06-10-2015 12:58 AM
    Hi Jim,

    thanks for your answer! This helps! 

    Best wishes Jessica