CA Service Management

 View Only

Archiving old Catalog requests

  • 1.  Archiving old Catalog requests

    Posted Apr 02, 2026 01:28 PM

    Good day,

    I need to archive old Catalog requests from my MDB. This is the query from the techdoc for archiving requests. It does nothing. Can anyone please help?

    USE mdb
    GO
    DECLARE    @return_value int
    EXEC    @return_value = [dbo].[usm_sp_archive_data]
           @p_object_type = 'Request',
           @p_date = '2017-03-31',
           @p_bu = 'xxx Municipality'

    SELECT    'Return Value' = @return_value
    GO


    -------------------------------------------