Uploaded image for project: 'ZABBIX FEATURE REQUESTS'
  1. ZABBIX FEATURE REQUESTS
  2. ZBXNEXT-6589

MSSQL by ODBC Agent Jobs and Backup

    XMLWordPrintable

    Details

    • Team:
      Team INT
    • Sprint:
      Sprint 75 (Apr 2021)
    • Story Points:
      1

      Description

      An extension of the existing MSSQL by ODBC template that also monitors failed SQL Agent jobs.

      Prerequisites: MSSQL by ODBC template should be configured and running on host

      It monitors runstatus, duration, nexrundatetime, nexrunstatusmessage, lastrundatetine, enabled but only runstatus, duration and enabled are created at discovery as standard to save database size but can be enabled on hosts needed.

      It currently only discover enables jobs

      Zabbix sql monitor user configured in the MSSQL by ODBC template needs the following permissions:

      USE msdb
      CREATE USER [zabbix] FOR LOGIN [zabbix]
      GRANT SELECT ON OBJECT::msdb.dbo.sysjobsteps TO zabbix
      GRANT SELECT ON OBJECT::msdb.dbo.sysjobs TO zabbix
      GRANT SELECT ON OBJECT::msdb.dbo.sysjobhistory TO zabbix
      GRANT SELECT ON OBJECT::msdb.dbo.sysjobschedules TO zabbix
      GRANT SELECT ON OBJECT::msdb.dbo.syscategories TO zabbix
      GRANT SELECT ON OBJECT::msdb.dbo.log_shipping_monitor_secondary TO zabbix
      GRANT SELECT ON OBJECT::msdb.dbo.log_shipping_monitor_primary TO zabbix
      GRANT SELECT ON OBJECT::msdb.dbo.sysjobhistory TO zabbix

       

      I also included the actual MSSQL by ODBC template with backup monitor integrated in it. This will monitor if missing SQL Backups.

        Attachments

          Activity

            People

            Assignee:
            mchudinov Maxim Chudinov
            Reporter:
            maand75 Mathias Andersson
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: