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

MSSQL by ODBC Agent Jobs and Backup

XMLWordPrintable

    • Sprint 75 (Apr 2021)
    • 1

      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.

        1. MSSQL by ODBC Agent Jobs.yaml
          10 kB
          Mathias Andersson
        2. MSSQL by ODBC Backup with backups.yaml
          161 kB
          Mathias Andersson

            mchudinov Maxim Chudinov (Inactive)
            maand75 Mathias Andersson
            Team INT
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: