init_config:

instances:
  - server: <server_name>
    user: <user_name>
    pass: <password>
    port: <port>             # Optional

    queries:               # Optional
      - query: select TIMESTAMPDIFF(MINUTE,start_time,end_time) as mins from jefbdpdb.J_JOB_EXECUTION join jefbdpdb.J_JOB_INSTANCE on jefbdpdb.J_JOB_EXECUTION.job_instance_id=jefbdpdb.J_JOB_INSTANCE.id join jefbdpdb.J_JOB on J_JOB_INSTANCE.job_id = J_JOB.id and J_JOB.group_structure = 'one4P->StageToBase' join (select max(id) jex_id, job_instance_id as job_instance_id_jex FROM jefbdpdb.J_JOB_EXECUTION where start_time >= now() - INTERVAL 2 HOUR group by job_instance_id) je_max  on J_JOB_EXECUTION.id = je_max.jex_id where J_JOB_EXECUTION.start_time >= now() - INTERVAL 2 HOUR and J_JOB.name='ADAP_STAGE_TO_BASE_ap_southeast_1a_adopp' and status='SUCCESS'
        metric: app.mins.ap_southeast_1a_adopp
        tags:               # Optional - only applied to this custom metric query, will not affect default mysql metrics
          - ADAP_STAGE_TO_BASE_ap_southeast_1a_adopp
        type: gauge
        field: mins
        min_collection_interval: 2700

      - query: select TIMESTAMPDIFF(MINUTE,start_time,end_time) as mins from jefbdpdb.J_JOB_EXECUTION join jefbdpdb.J_JOB_INSTANCE on jefbdpdb.J_JOB_EXECUTION.job_instance_id=jefbdpdb.J_JOB_INSTANCE.id join jefbdpdb.J_JOB on J_JOB_INSTANCE.job_id = J_JOB.id and J_JOB.group_structure = 'one4P->StageToBase' join (select max(id) jex_id, job_instance_id as job_instance_id_jex FROM jefbdpdb.J_JOB_EXECUTION where start_time >= now() - INTERVAL 2 HOUR group by job_instance_id) je_max  on J_JOB_EXECUTION.id = je_max.jex_id where J_JOB_EXECUTION.start_time >= now() - INTERVAL 2 HOUR and J_JOB.name='ADAP_STAGE_TO_BASE_ap_southeast_1b_adopp' and status='SUCCESS'
        metric: app.mins.ap_southeast_1b_adopp
        tags:               # Optional - only applied to this custom metric query, will not affect default mysql metrics
          - ADAP_STAGE_TO_BASE_ap_southeast_1b_adopp
        type: gauge
        field: mins
        min_collection_interval: 2700