DX Infrastructure Manager

Expand all | Collapse all

MS SQL Job status monitoring

Jump to Best Answer
  • 1.  MS SQL Job status monitoring

    Posted 05-20-2020 01:50 PM
    Hi-
    My organization was using ca UIM. Hope this is the community for that too.

    I want to setup monitoring for MS SQL job status monitoring.

    Is that possible with UIM.

    Please help.

    ------------------------------
    RoushanK
    ------------------------------


  • 2.  RE: MS SQL Job status monitoring

    Posted 05-20-2020 01:53 PM
    yes see the sqlserver probe
    http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/sqlserver-sql-server-monitoring.html

    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: MS SQL Job status monitoring

    Posted 05-22-2020 11:25 AM
    Hi Gene.

    I checked the probe article.

    I didn't find any metric which could monitor the sql agent jobs/ other jobs  which are running long than their scheduled time.

    Can you please help.

    Thank you,



  • 4.  RE: MS SQL Job status monitoring

    Posted 05-22-2020 11:36 AM
    The question has changed from job monitoring to just those taking too long, and for that you are correct the probe doesn't have a metric for that. It might be possible to setup a custom checkpoint to fulfill the need.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 5.  RE: MS SQL Job status monitoring

    Posted 05-22-2020 11:36 AM
    Supported SQL Server Versions
    The following table describes the checkpoint metrics, which are supported on SQL Server versions 2000, 2005, 2008, 2012, 2014, and 2016.
    Checkpoint Metric SQL Server 2012/SQL Server 2014/ SQL Server 2016 SQL Server 2005/SQL Server 2008 SQL Server 2000
    active_connection_ratio Yes Yes Yes
    active_users Yes Yes Yes
    agent_job_failure Yes Yes Yes



    http://techdocs.broadcom.com/content/broadcom/techdocs/us/en/ca-enterprise-software/it-operations-management/ca-unified-infrastructure-management-probes/GA/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-metrics.html
    Agent Job Failure
    -
    -
    15
    Major
    Monitors agent jobs which failed during the defined threshold interval (in minutes).
    4.4


    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------



  • 6.  RE: MS SQL Job status monitoring
    Best Answer

    Posted 05-22-2020 11:45 AM
    There is no checkpoint to check LONGER than scheduled time..
    As David said this would have to be a custom query.
    You can use the checkpoint for long-running jobs and see the threshold to a custom time.
    but you can not have it use configured scheduled time set up in the job.



    ------------------------------
    Gene Howard
    Principal Support Engineer
    Broadcom
    ------------------------------