.. _SNMP-database-maintenance:

SNMP Trap: Database Maintenance
-------------------------------

.. _19.2.1|VOSS-542|EKB-1564:

A trap is generated when the database maintenance schedules are not set up.

Severity Messages:

* ``ERROR: Database maintenance not scheduled``

.. rubric:: Example hourly notifications generated by the ``data/Alert`` instance in the Database

::

   Notification message from (1, 3, 6, 1, 6, 1, 1):('10.120.1.203', 60578):
   Var-binds:
   1.3.6.1.2.1.1.3.0 = 16128700
   1.3.6.1.6.3.1.1.4.1.0 = 1.3.6.1.2.1.88.2.0.1
   1.3.6.1.2.1.88.2.1.1.0 = Database Maintenance
   1.3.6.1.2.1.88.2.1.3.0 = ID: TRANSACTION_DATABASE_MAINTENANCE-VOSS-UN-1, Code: -1, Occurences: 27, Latest Occurence: 2019-08-23T10:06:35.405Z
   1.3.6.1.2.1.88.2.1.5.0 = 1
   1.3.6.1.2.1.1.5.0 = VOSS-UN-1


.. rubric:: Example warnings raised once through platform monitoring

   
TRANSACTION DATABASE MAINTENANCE NOT SCHEDULED 
   
.. index:: schedule; schedule add
.. index:: schedule; schedule time
.. index:: voss; voss transaction archive
.. index:: voss; voss transaction delete

::

   Notification message from (1, 3, 6, 1, 6, 1, 1):('10.120.1.203', 5194):
   Var-binds:
   1.3.6.1.2.1.1.3.0 = 16128774
   1.3.6.1.6.3.1.1.4.1.0 = 1.3.6.1.2.1.88.2.0.1
   1.3.6.1.2.1.88.2.1.1.0 = ERROR: Database maintenance not scheduled
   1.3.6.1.2.1.88.2.1.3.0 = TRANSACTION DATABASE MAINTENANCE NOT SCHEDULED - SETUP SCHEDULE FOR REGULAR MAINTENANCE
   1.3.6.1.2.1.88.2.1.5.0 = 1
   1.3.6.1.2.1.1.5.0 = VOSS-UN-1

.. rubric:: Resolution

Create schedule and time:

With for example a schedule name ``dbtxn``:

**schedule add dbtxn voss transaction archive**  or **schedule add dbtxn voss transaction delete**

**schedule time dbtxn weekly 0**

See: :ref:`enable_database_schedule`.