DX Unified Infrastructure Management

 View Only
Expand all | Collapse all

Is there a Metric or Way to monitor in MS SQL Server if a any backup job has completed or not?

  • 1.  Is there a Metric or Way to monitor in MS SQL Server if a any backup job has completed or not?

    Posted Jan 22, 2018 09:39 AM

    I see there is there are metrics for a backup running and its length however is there a way just to simply see if a backup ran and if it completed successfully or not at all for Microsoft SQL? We are looking to eventually put together a dashboard that you can look at the server and see if the backup that was supposed to run that night ran and if it completed successfully or not.



  • 2.  Re: Is there a Metric or Way to monitor in MS SQL Server if a any backup job has completed or not?
    Best Answer

    Posted Jan 22, 2018 10:52 AM

    Hi,

     

     

    If none of the available metrics meet your requirement, try creating a "custom checkpoint" which could suffice wherein you can have your own SQL query to monitor the backup status.

    Below link should give a fair idea for creating a custom checkpoint :
    https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/sqlserver-sql-server-monitoring/sqlserver-im-configuration#sqlserverIMConfiguration-(Optional)CreateCustomCheckpoint

     

    You might also find some Event IDs that can come in handy to track this.

    For example:

    https://msdn.microsoft.com/en-us/library/cc645604.aspx

     

    Regards,

    sinab